Smartsheet Basics

Smartsheet Basics

Ask questions about the core Smartsheet application: Sheets, Forms, Reports, Dashboards, and more.

How to Work Around Order of Operations in Form Logic?

edited 02/26/25 in Smartsheet Basics

I'm working on a form with some fairly complicated logic rules, and I keep running into an issue where a field - that should be hidden due to logic rules - is showing up by default despite user form selections.

Basically, this form allows users to create work requests based primarily on a field where they choose a request type or types (multi-select dropdown list). Here's the default view for the form:

These submissions all need to also choose a location where the work will take place, and depending on the request type, there are different ways to record that location.

The most common method for recording location is a text/number field where users can enter a Location ID. For certain request types, that is the only way to record a location. In other cases, I've provided a checkbox for "I don't know the Location ID", which when checked pulls up a dropdown list of locations and removes the Location ID field. Here's that logic:

Now this all works perfectly well and good when all my logic rules that contain this field are part of that first "Request Type" dropdown menu. However, I run into my issue when I try to put that "I Don't Know the Location ID" checkbox in the logic of a field that's subordinate to the original "Request Type" field. Here's what happens:

For one of my Request Types, there is logic to bring up a field called "Location Type". If I create a logic rule for a Location Type selection that brings up the "I Don't Know the Location ID" checkbox, the form logic breaks and the "Location ID" field is now visible by default:

The most annoying thing here is that if I change the vertical order of form elements in the form editing - that is, by moving the "Location Type" field above the "Request Type" field, it fixes the issue and the "Location ID" field behaves as expected. But now I've got users having to fill out the form from bottom up, and I'm certain that will cause human errors.

Anyone know how to work around this?

Tags:

Answers

  • Community Champion

    Hi @walter.dinsmore

    There must be some contradicting logic which is showing the Location ID by default. It will help if you can share the entire logic list that you've created in the form.

    Thanks,

    Aravind GP| Delivery Manager

    Atturra Data & Integration

    M: +61493337445

    E:Aravind.GP@atturra.com

    W: www.atturra.com

  • Hi @AravindGP thanks for answering, here's the full logic set (apologies in advance for this being pretty long):

    You can see that the "Request Type" field has a number of different logic rules. Now, as long as the "Location Type" field has no logic applied using the "Don't Know Location ID" checkbox field, the "Location ID" field remains hidden by default, as expected. Here's the logic that seems to be breaking things:

    Hopefully that clears things up a bit. I'm happy to share details on any individual logic rule, but will hold off to keep this post from getting too long. Thanks!

  • Community Champion

    Hi @walter.dinsmore

    It is still tough to identify the root cause. Would you be willing to do a call with screen share? If yes, please send me an invite to my email - aravind.gp@atturra.com

    Thanks,

    Aravind GP| Delivery Manager

    Atturra Data & Integration

    M: +61493337445

    E:Aravind.GP@atturra.com

    W: www.atturra.com

Trending in Smartsheet Basics