-
How do I set a form logic to exclude weekend?
How do I set a form logic to exclude weekend in such a way that when the Date Created falls on a Friday and the Date Required is on Monday (next week) that it will show a hidden text field (to justify the urgency)?
-
Add Contains Logic in Forms
Add additional options in Form logic such as the options provided for conditional formatting. The limited Form logic options make it challenging for certain inputs/responses. Example: for a question being answered with number format "0", if the logic option is "contains" then it will be applied to any number that contains…
-
Basic Logic in Forms - Not working
Hi all, Im setting up a form, and what should be quite simple doesnt seem to be working for a logic request. I have a question midway through the form, if the user selects the anser 'Yes' from the dropdown (field A), a field appears to answer (Field B). If its a no, then the field stays hidden and move on to the next…
-
Merged: Form Data Validation that compares fields to each other
This discussion has been merged.
-
Help with Nested Form logic
Hello all. I had a very successful onboarding form with logic showing up depending on the selections. It worked well. I was then asked to build an offboarding portion into this. I have created the columns that are required to capture for offboarding, and setting up the logic for the onboarding/offboarding selection works…
-
Feature: Allow pasting of multiple field names in Conditional Logic
I'd like to be able to paste MULTIPLE field names into the "Then show the following fields" area in Form Editing > Field Settings > Logic > "Then show the following fields" box. Similar to how we can do so when pasting names in sharing settings.
-
I have a drop down for Objective based on selection I would then like to auto populate KPI
I have a drop down for Objective based on selection I would then like to auto populate a drop down field in the KPI formula. I don't think an if statement will work as the KPI drop down is a multi select - one objective can have 4 KPI's. I tried adding logic but it does not go deep enough, or I am doing it incorrectly.
-
Based upon the answer to a question on a form, can I direct to another form?
If I have a form and the 1st question has 3 options, can I use the logic to direct to 3 other forms so that the questions are relevant to the answer selected? For example, question 1 has 3 answers, A, B, C. If they pick A, they are directed to smartsheet form A, if they answer B, they are directed to smartsheet form B and…
-
Form Conditional Logic
Is it possible to show/hide some box/columns on a form depending on the result of a dropdown selection?
-
Form with multiple logic conditions
I have a form with multiple logic conditions (15). The logic is that who fills the form is being asked how many items he/she wants to insert/record. If 1 is chosen, the form will show only one field (Item 1) and if 2, two fields will show (Item 1 and Item 3) and so on. No matter how items (1 to 15) are chosen, the Form…