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

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

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

Answers

  • Paul NewcomePaul 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"?

  • What I would like to do, in a form, is use the [email protected] input to find the [email protected] 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 NewcomePaul 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.

  • 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?

  • 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 NewcomePaul 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.

  • 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?

  • 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 NewcomePaul Newcome ✭✭✭✭✭

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

Sign In or Register to comment.