-
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…
-
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.
-
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…
-
How do I remap my Smartsheet Form?
I have a Smartsheet form used to collect and manage training requests. The form is set up with a client selection dropdown, followed by additional fields specific to each client. For instance, selecting "Dignity Health" in the client field triggers the appearance of Dignity Health-specific fields such as Client Host…
-
How to Work Around Order of Operations in Form Logic?
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…
-
Forms Logic Flowchart
Is there a way to download/extract the Forms Logic in to a flowchart to see the decision tree? I know I could take screen shots and paste into PowerPoint for example, but wasn't sure if there was a quick way to extract the logic. Thanks in advance!
-
Setting values from form to zero
I have a form for customer feedback with ratings 1-5 and an N/A option. I'd like to apply logic such that the N/A value is set to 0. So I can work with it in other columns with formulae, avg rating, etc.
-
Request for Update Automation Logical Conditions
Hello, It would be incredibly useful to have the option to build a logical condition within the automation request for updates. Currently, our form is sent to our sales reps weekly for updates, but user errors often occur as they miss certain boxes. I am unable to implement the logic that if one box is checked, the other…
-
Does reordering columns impact any other existing logic? The column title would remain unchanged
Does reordering columns impact any other existing logic (datamesh, formula, workflow, helper columns)? The column title would remain unchanged. Specifically, is there any reason this could impact a helper column using a formula that references the column being reordered?
-
Is there a way to logic-trigger different custom labels/descriptions for the same field?
Is there any way to set up logic in either Dynamic View or Forms so that the trigger displays the same field but changes its custom label? I am building a solution for a performance assessment process where the base questionnaire is the same; however, different departments need to phrase the question differently. Example:…
-
compare multi-contacts to a text string
Hi everyone, I am building a schedule for my team that will confirm if a combination of assigned staff 'assigned to' are trained to do a specific task 'task combos'. the 'staff trained in this task' is a text column that is using JOIN(COLLECT) to combine contacts who are trained in a task, these are in different columns…
-
How can I add days to a date field within a logic formula to output a true/false value for a chkbox?
My objective is to create a new column where a box is checked once the row meets desired criteria. The checkbox will help me filter-out rows that will be synced via a Salesforce Connector workflow. The logic criteria is as follows: "Overall Status" = Blue (complete)….and…. "Working Launch" Date + 7 Days </= Today's date…
-
Total Hours with the same person assigned
I have created the below sheet. I am trying to total the hours used for rows matching "person" E.G In the first row "Richard Irwin @ FM" I'm looking to total the rows below Project Staffing that have Richard attached to it in the column "Person" Any ideas?
-
Forms - With Conditional Logic - Not working
Okay first I used to set these up for Medtronic, np, but my previous employer did not have Smartsheet, so I am out of practice (AND using a personal account). @rrenee tried to help before, but something is not working. Let's go simple. I set this CL based on selecting 1 of the many reports in the Report Category list. What…
-
Form Logic
Hi! Needing help with conditional logic within a form. So, I built a form for Training, Travel & Development Requests within my organization. With that, I have built in approvers (the associate chief operating officer is a drop down to select the applicable approver). What I want the form to do is: When a submitter selects…