"and" logic for multiple condition in a form

MarleneUKG · 10/25/23

Hello,

I created a form for which I would like to display a field if 2 criteria are met BOTH -> currently a "OR" logic is automatically set:

Where can I change the "or" to "and"?

Thank you

jmyzk_cloudsmart_jp · 10/25/23

HI @MarleneUKG

In the current Smartsheet form configuration, only nested "OR" conditions are supported. 😅

A potential workaround is to design a separate column in your sheet that fulfills your "OR, OR, AND" criteria. You can then reference this column's value to set up the desired form logic condition.

David Dolch · 03/01/24

@jmyzk_cloudsmart_jp How would you do this?

I have two questions, call them A and B. If A AND B and both false, then I want to display a third question. But only if BOTH are false.

I can easily add a column in the underlying sheet that has logic that says, if A AND B are false, then ask the third question. I can then add that as a hidden input on the form and key the logic off of that.

The issue is, that logic does not trigger until the row is updated by submitting the form. So the logic in the column is useless until after the form is submitted, which defeats the whole purpose.

jmyzk_cloudsmart_jp · 03/02/24

@David Dolch

You are right. My oversight.

Occasionally, we implement a sequence of negative checks as a prerequisite to proceeding with specific inquiries. (see example) This approach only displays subsequent questions if the preceding question satisfies a particular condition. (e.g., if Question 1 is satisfied, then Question 2 is shown; if Question 2 is met, then Question 3 appears, and so forth).

But this approach does not meet the need where you want to show all the questions and allow a user to answer the last question if all previous questions satisfy the condition.

https://app.smartsheet.com/b/form/98b41ca4fb86472b9a0e347a42bb98ca

hilaryj · 10/16/24

https://community.smartsheet.com/discussion/comment/401529#Comment_401529

Can you give an example of this? i am having a similar issue.

jmyzk_cloudsmart_jp · 10/17/24

@hilaryj

Here's a workaround for using a dropdown list and a helper column to achieve "AND" logic in their Smartsheet forms:

Create the Dropdown Column: First, define a dropdown column in your main sheet with options such as "A", "B", "A & B", depending on the conditions you want to check.
Add Helper Columns: Next, add helper columns for each condition. For instance, if you have options "A", "B", and "A & B":
- Helper Column for A: This column will have a formula that checks if the dropdown selection is either "A" or "A & B". You can use a formula like =IF(CONTAINS("A", Condition@row), 1).
- Helper Column for B: Similarly, this column will check for "B" or "A & B" using a formula like IF(CONTAINS("B", Condition@row), 1).
Configure Form Logic:

By using these helper columns, you can control the flow of your form to mimic "AND" logic conditions, even though Smartsheet forms primarily support "OR" conditions by default. Remember to adjust the visibility settings in your form accordingly to reflect the values in these helper columns.

https://app.smartsheet.com/b/publish?EQBCT=91c54e2933004477bf50c13176abd560

Here is the link to the form.

https://app.smartsheet.com/b/form/21024e03bba040a9877fbdb7b15e7d90

"and" logic for multiple condition in a form

Answers

Help Article Resources

Categories