-
Can you set up logic in forms that have a start date?
Working on a project that I need to add form logic to but don't want it to start for a week? Is there a way to have a start date in the future OR will it only start once added?
-
Form not using logic despite being set up.
Hi, I have set up a form which will be filled out whenever a machine encounters a downtime period and have set up certain logic to show questions depending on the previous answer. For example answering 'Machine' with either "EMZ 3612" or "EMZ 3610" will show the 'EMZ Downtime Type' question and so on for other machines. I…
-
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)…
