-
IF formula is not working as expected
I'm sure I'm doing something wrong with this formula, but I can't figure out :( Any help is much appreciated!! I'm trying to add a text to the column "Dispute", so if the # of days in the "Days from Audit" column is equal or higher to 10 text will be "Dispute not applicable" or if the # of days in the "Days from Audit"…
-
combining 2 forms into 1 - conditional logic
Hello I am trying to combine 2 forms into 1 super form (a business order form) The logic is spot on for on 1 & 2 form but the combined form shows all of the fields in step 2 when it should be if a certain product is chosen then only show these fields. It looks like the logic is hierarchy from the combined form field "form"…
-
Smartsheet Logic
We have a request tracker that is linked to a request form - each category has a different form and there are questions/fill in options associated with each. Recently, all are now showing on each and/or there are missing items. However, the logics created have not changed. Any reasoning why?
-
What it the limitation when using form logic to show dropdown lists?
We have a case where a form is being used by managers to enter info about their direct reports. In the sheet, there is one column of direct reports for every manager. When the manager selects their name in the form, logic causes a new field with all their direct reports to appear as a dropdown. We have a little over 100…
-
Modern Forms with conditional logic is now available on Smartsheet Gov!
Hi Community, We’re excited to announce that Modern Forms with Conditional Logic has come to Smartsheet Gov! Modern forms with conditional logic in Smartsheet Gov empowers your team to collect and act on information faster and with greater confidence on the Smartsheet Gov platform. Ask the right questions to the right…
-
Form Logic with Multiple select Drop Downs
I have a dropdown column with 11 multi-select (all that apply) options that I want to write logic off of to have the correct corresponding columns then show in the Form. Any one done this before? The logic drop downs don't see to align with what I need...short of writing hundreds of logics for possible scenarios. Any one…
-
Autofill if a column contains vs. if true or false
trying to figure out if/how i can make a sheet auto fill a column based "if contains" not "if true"/"if false" Ex: Door Schedule for production Column to report on = Door Size Reporting Column = Drop down of hinge counts If "Door Size" contains "8-0" - Hinge Counts = 4 If "Door Size" contains "7-0" - Hinge Counts = 3 What…
-
#INVALID DATA TYPE (Simple True False Logic)
I've been trying to do a simple check of whether or not the entry from the form has a returned value that is either yes or no and it checks 3 cell locations to see if any returned yes. The 3 columns are Dropdown lists for Yes/No and the Status is a Text/Number, is that the issues? If not how do i fix that?
-
Is there a way to add/remove radio button options based on the logic of a previous answer?
I’m putting together an employee shirt order form. I’d like to make it so they select the shirt first. Next question is size, and the next is color. However, not all sizes and colors are available for all shirts. Using logic, would the radio buttons for size and color adjust based on the shirt they select?
-
HUGE ISSUE WITH SMARTSHEET INTAKE FORMS!
HI EVERYONE! PLEASE NOTE THAT THIS IS A HUGE ISSUE IN THE SMARTSHEET FORMS! Using the Form logic, I have kept some "required" field hidden. But DESPITE these fields being hidden, my end users are able to click the SUBMIT button and submit the form! How can we submit a form without filling in ALL its mandatory fields?? I AM…