The category property is a SharpCloud specific property that all attributes possess, denoting what category an item is assigned to. 


You can reference this property in functions such as the IF and WHERE statement, to perform calculations on a specific category or categories of items.


Type of Data Returned


Returns the name of the item category.




Using a calculated value to express the category name and item name together.


CONCAT([category, “:”, name])


Creating an IF statement to start the process of a “nested” calculation process.


IF(category == ‘Program’, 2, (IF(category == ‘Project" , 1, 0))


This calculation will return a “2” value for an item that is a ‘Program’, or a “1” for a Project, and for other categories will return a 0.