-
Dynamic View Logic blocked
I am having an issue not being able to add this block of logic to a Dynamic View. I have double checked and the name is unique. Any ideas why?
-
Generate Document Automation, select 1 of 3 contracts
Hello, one of my workflows includes an automation to generate a contract. It started as 1 type of contract and worked great. I have a check box to "generate contract" and when that is checked, the automation is triggered. Then we created different forms of the contract: we have 1 for veterans, 1 for people that pay in full…
-
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?
