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