The duration of an item is a built in-property of SharpCloud, which can be edited on any item. By default, the duration is 31, and will use the start date as the base value.

Type of Data Returned

Will return the number for the duration of the item.

Examples

Extending the duration of the items by 20 to show an extended phase

durndays+20

Determining if an item is deemed “long” or “short” based upon its duration

IF(durndays>100, “long”, “short”)