Skip to main content
Validation Rule: SET [...]

#EN #Excel #Validation

Updated over 2 years ago

Validation rule to use

Use the sentence SET [...] to set a field to a specified value.
Multiple SET can be used in the same validation rule.

Validation rules available

SET U when Field is Value

Allows to set an option button field to a specific value according to a targeted value entered in a specified field.

Alternative rules:

  • SET S when Field is Value

  • SET NC when Field is Value

  • SET C when Field is Value

  • SET Yes when Field is Value

  • SET No when Field is Value

  • SET NA when Field is Value

Example: SET U when Temperature is greater than 4

NB: "NA" applies for numeric, option buttons, date and time fields/columns, whereas "N/A" applies for text and drop-down list fields/columns.
You may always use "NA" to avoid confusion, but visually on the form it will look different.
i.e.: Option buttons display "NA" and a numeric field will display "N/A", but needs to be set using "NA". A text field will display the value you set them to, which will not matter aside from the fact it might look different than the other fields/columns if you use "N/A" vs. "NA".

A photo and/or signature field/column cannot be set to N/A.

Keywords available with this validation rule

SET Now

SET Now when Field is not empty

Allows to set a date, time or date/time value automatically if a specified field is not empty.
You may use the keyword Today or Now.
You can target a column instead of a field as well.

Alternative rules:

  • SET Now when Field is Value

  • SET Now when Field is not Value

  • SET Now when Field is Field

  • SET Now when Field is not Field

  • SET Now when Field is lesser than Value

  • SET Now when Field is < Value

  • SET Now when Field is greater than Value

  • SET Now when Field is > Value

  • SET Now when Field is lesser than Field

  • SET Now when Field is < Field

  • SET Now when Field is greater than Field

  • SET Now when Field is > Field

  • SET Now when Field is between Value and Value

  • SET Now when Field is not between Value and Value

  • SET Now when Field is between Field and Field

  • SET Now when Field is not between Field and Field

  • SET Now when Field is between Value and Field

  • SET Now when Field is not between Value and Field

  • SET Now when Field is between Field and Value

  • SET Now when Field is not between Field and Value

Keywords available with this validation rule

Did this answer your question?