Calculated Values

Round Up (ROUNDUP)
The ROUNDUP function will round the value up to the closest integer. Syntax ROUNDUP(x) Parameters x = the value that the user wishes to roun...
Wed, 29 Jul, 2020 at 10:47 AM
Square Root (SQRT)
The SQRT function will find the square root of a number. Syntax SQRT(x) Parameters x = Value for which the user wants to find the square roo...
Wed, 29 Jul, 2020 at 10:47 AM
Substring (SUBSTR)
The SUBSTR function will return a specified part of the string. The position value is zero based and must be less than the length of the string. The length ...
Wed, 29 Jul, 2020 at 10:48 AM
Sum (SUM)
The SUM function is one of the most widely used functions in SharpCloud, it has a wide range of applications and is used to simply add an array of numbers t...
Wed, 29 Jul, 2020 at 10:50 AM
Tag List (TAGLIST)
TAGLIST returns a list of assigned tags. It can return all tags or tags assigned to a specified tag group. This function is CASE SENSITIVE. Syntax T...
Wed, 29 Jul, 2020 at 10:54 AM
Today (TODAY)
TODAY function will return the item’s today datetime. Syntax TODAY() Parameters None Data Type Returned TODAY will return a date or ...
Wed, 29 Jul, 2020 at 11:21 AM
To Lower (TOLOWER)
TOLOWER returns a string as entirely lower case. Syntax TOLOWER(“x”) Parameters x = The string that the user wishes to return as lower case....
Wed, 29 Jul, 2020 at 11:22 AM
To Upper (TOUPPER)
TOUPPER returns a string as entirely upper case. Syntax TOUPPER(“x”) Parameters x = The string that the user wishes to return as upper case....
Wed, 29 Jul, 2020 at 11:24 AM
Union (UNION)
The UNION function will return the unique values from two arrays, removing any duplicate values between the two arrays. The two arrays will have to be of th...
Wed, 29 Jul, 2020 at 11:25 AM
Where (WHERE)
Note: This function can only be used for ITEMS and must be created in the items tab. The WHERE function is designed to find items that meet specific con...
Wed, 29 Jul, 2020 at 11:29 AM