Calculated Values

Owner (owner)
The owner property is a SharpCloud specific property which denotes the owner of an item. An owner can be selected on an individual item basis within SharpCl...
Tue, 28 Jul, 2020 at 3:49 PM
Relationship Count (relcount)
This function is a good way of seeing how connected items are to other items in a story, by using the number of relationships that the item has.   Type of...
Tue, 28 Jul, 2020 at 3:50 PM
Resources Count (rescount)
You can use this function to see how many resources have been assigned to the item.   Type of Data Returned   This function will return the number of re...
Tue, 28 Jul, 2020 at 3:51 PM
Start (start)
Start date is a property that is generated for the date that is assigned as “start”. Unlike the created date, this can be amended. By default, SharpCloud wi...
Tue, 28 Jul, 2020 at 4:49 PM
Tag Count (tagcount)
This property is the number of tags, irrespective of tag group, that the item has.   Type of Data Returned   This function will return the number of tag...
Tue, 28 Jul, 2020 at 4:50 PM
Absolute Value (ABS)
Absolute value is designed to return a positive number (integer or decimal).   Syntax   ABS(x)   Parameters   x = a value, either positive or negati...
Tue, 28 Jul, 2020 at 4:50 PM
Add Days (ADDDAYS)
This function will add a specified number of days to a date.   Syntax   ADDDAYS((x), y)   Parameters   x = a date. This is the date you wish to use ...
Tue, 28 Jul, 2020 at 4:51 PM
Add Months (ADDMNTHS)
This function will add a specified number of months to a date.   Syntax   ADDMNTHS((x), y)   Parameters   x = a date. This is the date you wish to u...
Tue, 28 Jul, 2020 at 4:51 PM
Add Years (ADDYEARS)
This function will add a specified number of years to a date.   Syntax   ADDYEARS((x), y)   Parameters   x = a date. This is the date you wish to us...
Tue, 28 Jul, 2020 at 4:52 PM
Average (AVG)
Finds the average (mean) of an array of numbers or dates.   Syntax   AVG([x,x,x,x…])   Parameters x = a number or date that you wish to be included i...
Tue, 28 Jul, 2020 at 4:53 PM