Skip to main content
VIVIDMAX
G
Written by Gary Ditsch
Updated over a year ago

What is VIVIDMAX?

The max value from a select field of ServiceNow records

Syntax

VIVIDMAX(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

=VIVIDSMAX(pm_project, active=true, 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.

Did this answer your question?