How far can Conditional Logic go to screen? Screen does not work

Doyle54

I am trying to use:

CONTAINS(OnePt, @cell), [OnePt]:[OnePt]

Essentially I am trying to use Location - OnePt - to see if there is a record of OnePt input into a record.

If I cannot use the logic, can you explain the scenario and cell in a column I can use to execute the logic?

As always, Big thank you!

Carey

Paul Newcome

I'm not sure I follow. Are you trying to flag duplicates, or are you trying to search a column called [OnePT] for the text "OnePT"?

Doyle54

Form Logic Example 2.jpg

Form Logic Example.jpg

What I would like to do, in a form, is use the location@row input to find the padname@row that match that location. With 344 Pads I would like to screen each new pad inspection to just the pads that fit that location.

Paul Newcome

So you want to essentially filter the list of available selections in the [Pad Name] field based on the selection in the form field of [OnePT]?

If I understand correctly, this is not possible in Smartsheet forms. Feel free to Submit a Product Enhancement Request when you are able though, as this type of logic would be very useful in multiple scenarios.

Doyle54

Paul - I have a session scheduled in 9 minutes. They might have an answer.

Is it possible to use a column and a cell (FieldTest1) to perform a VLookup and return a yes or no to the form?

Doyle54

Form Logic Example 3.jpg

In this case, the Employees A is already created. And only the Dropdown for A is shown. Right? Can I store dropdowns and simply reference them?

Paul Newcome

You cannot use the VLOOKUP directly in the form to fill fields as the user is filling out the form. You would have to use the VLOOKUP on the sheet to be run on new rows after the forms are submitted.

Your most recent screenshot is possible though. You would have separate dropdowns for each Employee and use the logic to determine which Employee Field (A, B, or C) is shown on the form, but the selections within a dropdown column cannot be filtered. So you can use logic to Show the Employee A field, but if there are multiple selections within the Employee A column then they will all be available. You wouldn't be able to build in logic to say Show "Employee A" and options 1, 3, and 5.

Doyle54

I think I get my one path that would work. I create Fields - Columns in my Archive Sheet and input the Well Pads of the 9 oil companies. These Fields have nothing to do with the rest of the row(s) they simply hold the key to a dropdown of well pad names. Does this make sense? I really have to find a way to drive the Officers to standardize their Pad Names, a critical key to statistical analysis that has been requested.

Your thoughts?

Doyle54

Help me thank you by adding above.

Do i have to always input into the dropdown input option or is there a way to simply reference a column in the sheet that has the options?

Paul Newcome

The options would need to be listed in the Dropdown Column Properties.