Multiple Logic Requirements in Forms

Dean Johnson

Is there a way within a Smartsheet Form, two 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.

Andrée Starå

Hi @Dean Johnson

I hope you're well and safe!

Unfortunately, it's not possible now, but it's an excellent idea!

Please submit this as a Product Feedback or Idea (If it hasn't been added already) when you have a moment.

• A possible workaround would be to use the Premium App, Dynamic View.

Is that an option?

I hope that helps!

Be safe, and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Ida Skou

@Andrée Starå
I have the same issue, and we do have Dynamic View. Can you explain a bit more how Dynamic View could fix this problem?

Thank you. :)

Best, Ida

SoS | Dan Palenchar

Hello @Dean Johnson and @Ida Skou,

There is a workaround to solve this using logic chains and 1+ helper columns depending on design.

You can see this in the form below.

https://app.smartsheet.com/b/form/c4174bb6638447ea96ef43f93ad44daf

Ida Skou

Dear @Dean Johnson

Thank you very much for your reply. That can actually work. Great! :) Thanks again!

Best, Ida

NeilKY

@SoS | Dan Palenchar , dan, can you share screenshots of the form builder for this, along with the formula for the helper column? I can't make sense of it with the example alone.