-
ALL conditional logic not working on Form
None of the conditional logic is working on the form - though when I make a copy of the smartsheet, the copy's form is working as expected? Could there be some sort of default that is assigned when a copy is created? I am suspecting the issues lies in the smartsheet itself - not the form. As the form logic has not been…
-
Form Data Validation that compares fields to each other
I'm hoping for a custom validation option on form fields that compares them to one another. Specifically this is in regards to numeric fields: one field cannot be greater than the other field. To take that a step further, what I really need is the option to prevent the sum of certain fields from (1) exceeding the sum of…
-
Incorrect Argument Set for MATCH, IF, AND formula
Hi there, I feel like I'm close to a solution. I'm working in a symbol column that I would like to automate to turn either Gray or Green. I would like to match a row across different sheets, if specific columns are blank on the other sheet for the match row, I'd like to return a gray symbol, if any one of them is not…
-
Potential IF/AND with multiple criteria (each listed multiple times)
Okay, let's start out by saying I am so stuck I have no clue on how to create this formula! LOL Okay the formulas will be added to the PA - CAPA List sheet. The Training Report is the data source. This is just a small sample of my data (there are about 25K rows). In the sample on the Training Report you can see the names…
-
Additional formula logic: NOR, NAND, XOR and XNOR
Please add the other common formula logic: NOR, NAND, XOR and NXOR All these can be expressed with a combination of IF's, NOT's, AND's and OR's, but the formula gets long and difficult to follow—it's not as clean. And don't get me started on when you have long phrases as column headers to use as variables! Right now I can…
-
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…
