-
Logic not working properly.
I'm trying to add 5 different logics. If question number 2 "does not contain" 24, 23, 22, 21 or 20 I want the error box to come up. I enter in the first logic step and it works, once I start adding more it stops working properly. Now, when ANY number is entered for question 2 the error box appears. What am I doing wrong?…
-
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…
-
Based upon the answer to a question on a form, can I direct to another form?
If I have a form and the 1st question has 3 options, can I use the logic to direct to 3 other forms so that the questions are relevant to the answer selected? For example, question 1 has 3 answers, A, B, C. If they pick A, they are directed to smartsheet form A, if they answer B, they are directed to smartsheet form B and…
-
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…
-
Complex Form Logic Conditions
I really like that forms have some type of conditional logic, so that the users don't have to see fields that aren't relevant. But, it would be nice to add AND/OR logic. For example, the way it is now, conditions can only be based on the selection of a single field. With the addition of AND/OR conditions, we could combine…