-
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 and Logic: Renaming drop down item removes logic at form
When you have a form associated with a sheet, and then rename a drop down item at one of the columns for which logic is associated to, you will see the logic disappears at the form. This is an expected result since an error message appears (see screenshot below). I request this not happen. To leave the ability to rename a…
-
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…