-
Using smartsheet logic step in forms - new row created in backend sheet?
Hi, I have created a logic step where if the form user fills out yes to a question, two extra rows appear. I have tested the form and it works but the additional information appears in the back-end sheet as extra columns. Is it possible for the info to be separated into two different rows rather? We would like the basic…
-
Nesting IF, AND, and OR
Hello there! I am working on a project that will allow us to do a very quick visual check when a date is inside a work window. The problem occurs when a work window has two date ranges, this example being 07/16 to 07/30, and then another work window between 11/15 and 02/01. Not all work windows have two work windows, but…
-
Form Submission Restriction based on date lead time
Hi there!! I am working with a form that we'd like to put a restriction on if a date selected is within a certain time frame. Example - We're putting in place a minimum of 7days lead time for requests to be satisfied and would like the form to be unsubmittable until that requirement is met. I don't see a way to do this…
-
What is the best way to add table like data for user to fill in a form?
I am asking people to complete a form when their salary is split between projects/schools. (1) Name (2) Employee ID: (3) Start Date: (4) End Date: More than 1 project? Y/N *if more than one, I need the following for EACH project and some folks have 5-6 projects (5) Project name, (6) flat amount or (7)% of base salary, (8)…
-
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…
-
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…