Can a Smartsheet form use two levels of conditional logic?

Amy Logan

Hello, I am wondering if a Smartsheet form can be modified to use two levels of logic. I'm not seeing how to make this work, but wanted to check.

Logic desired:

1. User selects a 'Lane of Business' option from a drop down
2. Selecting any option from 'Lane of Business' forces the next question, 'High Level Support Needed' to appear
3. However, the possible selections shown as options under 'High Level Support Needed' change based on the selection made for 'Lane of Business;

For example, under 'Lane of Business', user selects the option 'Support'

Under 'High Level Support' needed, user then sees the options: A, B, C

However, if user selected 'eCommerce' instead under 'Lane of Business', then under 'High Level Support Needed', they might see only options D, E, F available

Thank you,

Amy

Andrée Starå

Hi@Amy Logan

I hope you're well and safe!

It's possible, but you need to define each option in different columns.

I developed a similar solution recently for a client, and there were a lot of options, so before you set it up in Smartsheet, I'd recommend documenting all the possibilities.

Would that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

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

✅了我的帖子(s)帮助或回答你吗r question or solve your problem? Please support the Community bymarking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

bhealey77486

I am trying to use two levels of logic and it does not appear to be working. Can additional logic be built into the form or is only one over-arching logic allowed?

My first question leads the user to two different sections based on the answer. From there, I'd like to build in additional logic under each of the two sections so the user is only presented with questions based on their answers. I'm unsure of how to make the secondary logic work. I have it set up in the same manner as the first logic (that is working).

Marvin Daniels

I don't know if this helps, but I've built an audit collector where the first selection on the form isaudit type(enrollee, enrollee on COBRA, dependent, dependent on COBRA), which determines the questions that appear. Each audit has it's own unique combination of the 40+ questions.

Audit 1 could be questions 1-10, 15, 25, 40

Audit 2 could be questions 1-10, 30-35

Each of the question fields are set with default ofpass. Auditor flips tofailas needed, but only the triggered questions for thataudit typeare recorded when the form is submitted, so on the sheet we just count all questions looking for pass/fail to calculate the score. All the blank questions are ignored as irrelevant for that particular audit.

This is working for us and doesn't require multiple logic levels, just one based on theaudit type. Is there any way you can put the decision point into one column instead of two? If so, this method could work for you.

bhealey77486

Here's what I am mean by having more than one form logic built into a form:

• Audit 1 is questions 1-10, 15, 25, 40
• Audit 2 is questions 1-10, 30-35
• But then within Audit 2, if question 30 is answered yes, it moves to question 35. If question 30 is answered no, it moves to question 31.