Multi Logic Form Example

This form was developed in response to a Smartsheet Community Question asking:


Is there a way within a Smartsheet Form, to have a field only show if two fields are equal to a certain value? i.e if field one equals x and field two equals y show field three.



Developed by School of Sheets Solutions Consulting

Smartsheet Partner Consultancy

How this form works

  • If Field 1 is x Field 2a will show, if not Field 2b will show.
  • If Field 2a is available *and* has the value y Field 3 will show.
  • Field 2b does not have the logic to allow Field 3 to show.
  • Practically, Field 2a and Field 2b would be identical other than the name.


Requires "x" for Field 3 to show

Select or enter value
Caret IconCaret symbol

Requires "y" for Field 3 to show

Since Column2 is "x" this field is displayed which has the logic to show Column4.

Select or enter value
Caret IconCaret symbol

Since Column2 is not "x" this field is displayed which lacks the logic to show Column4.

Select or enter value
Caret IconCaret symbol