I really like that forms have some type of conditional logic, so that the users don't have to see fields that aren't relevant. But, it would be nice to add AND/OR logic. For example, the way it is now, conditions can only be based on the selection of a single field. With the addition of AND/OR conditions, we could combine…
The Smartsheet intake form foundation lacks so much dynamic functionality and does not meet other applications minimum standards when it comes down to setting couple or logical multiple criteria on when a question should show/hide. I tried many ways to set up a logical criteria where if a user selected option 1 for the…
Hello everyone! I am building a data tracker sheet that will track event data sourced from a form that goes out to event coordinators. I'm trying to figure out a way to push them a 'new form' to fill out when they select that they have multiple events they need to submit. Ideally, I would like to automate this process…
Hello, I created an intake form for a project request. In the form there's a field where the submitter has to select from a dropdown list of Contract Information choices. Here are the automation logic I have: When I tested it by selecting the different options in the dropdown in the sheet column, this works correctly.…
I have logic set up in a dropdown field that says if this field contains X, show the Y field. My issue is that the Y field is showing regardless if X is selected from the dropdown or not. Anyone know why this is happening?
My boss wants to create a sheet that includes 4 different profile forms. I'm curious if this is even possible. Basically, we have 4 different excel docs that are profile forms, we want to try to combine these forms on a grid in Smartsheets but we want the fields to auto populate depending on which profile form is selected.…
I am trying to create an automation or formula to populate a cell. Here's the gist of what I am trying to accomplish: Only when a completed box in a column is checked → I want to populate another cell in that row with the Current User who checked the box. I would like this to populate automatically through the use of a…
Working on a project that I need to add form logic to but don't want it to start for a week? Is there a way to have a start date in the future OR will it only start once added?
Hi, I have set up a form which will be filled out whenever a machine encounters a downtime period and have set up certain logic to show questions depending on the previous answer. For example answering 'Machine' with either "EMZ 3612" or "EMZ 3610" will show the 'EMZ Downtime Type' question and so on for other machines. I…
This discussion has been merged.
