What is VIVIDSUM?
The sum of values from a select field of ServiceNow records
Syntax
VIVIDSUM(SN Table, Encoded Query, Field)
What are the different parameters required by the function?
SN Table - The system name for a table.
Encoded Query - The output of the condition builder in ServiceNow. This is used to filter down records on the defined ServiceNow table.
Field - The system name for a table on the already-defined table
Sample Usage
=VIVIDSUM(pm_project, active=true, budget_cost)
Notes about this function
There can only be one table defined in this function.
To get the encoded query, write it directly into the function bar, or go to a ServiceNow table, use the condition builder, copy the encoded query, then past it into the VividSheets function bar.