-
Merged: Conditional Drop Down List Values
This discussion has been merged.
-
Can I add logic on summery sheet field ?
I have added a check box in the summery sheet. which I want to be unchecked at certain frequency.
-
Forms and Logic: Renaming drop down item removes logic at form
When you have a form associated with a sheet, and then rename a drop down item at one of the columns for which logic is associated to, you will see the logic disappears at the form. This is an expected result since an error message appears (see screenshot below). I request this not happen. To leave the ability to rename a…
-
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…
