-
What it the limitation when using form logic to show dropdown lists?
We have a case where a form is being used by managers to enter info about their direct reports. In the sheet, there is one column of direct reports for every manager. When the manager selects their name in the form, logic causes a new field with all their direct reports to appear as a dropdown. We have a little over 100…
-
Modern Forms with conditional logic is now available on Smartsheet Gov!
Hi Community, We’re excited to announce that Modern Forms with Conditional Logic has come to Smartsheet Gov! Modern forms with conditional logic in Smartsheet Gov empowers your team to collect and act on information faster and with greater confidence on the Smartsheet Gov platform. Ask the right questions to the right…
-
Form Logic with Multiple select Drop Downs
I have a dropdown column with 11 multi-select (all that apply) options that I want to write logic off of to have the correct corresponding columns then show in the Form. Any one done this before? The logic drop downs don't see to align with what I need...short of writing hundreds of logics for possible scenarios. Any one…
-
Autofill if a column contains vs. if true or false
trying to figure out if/how i can make a sheet auto fill a column based "if contains" not "if true"/"if false" Ex: Door Schedule for production Column to report on = Door Size Reporting Column = Drop down of hinge counts If "Door Size" contains "8-0" - Hinge Counts = 4 If "Door Size" contains "7-0" - Hinge Counts = 3 What…
-
#INVALID DATA TYPE (Simple True False Logic)
I've been trying to do a simple check of whether or not the entry from the form has a returned value that is either yes or no and it checks 3 cell locations to see if any returned yes. The 3 columns are Dropdown lists for Yes/No and the Status is a Text/Number, is that the issues? If not how do i fix that?
-
Is there a way to add/remove radio button options based on the logic of a previous answer?
I’m putting together an employee shirt order form. I’d like to make it so they select the shirt first. Next question is size, and the next is color. However, not all sizes and colors are available for all shirts. Using logic, would the radio buttons for size and color adjust based on the shirt they select?
-
HUGE ISSUE WITH SMARTSHEET INTAKE FORMS!
HI EVERYONE! PLEASE NOTE THAT THIS IS A HUGE ISSUE IN THE SMARTSHEET FORMS! Using the Form logic, I have kept some "required" field hidden. But DESPITE these fields being hidden, my end users are able to click the SUBMIT button and submit the form! How can we submit a form without filling in ALL its mandatory fields?? I AM…
-
How to check if cell contains one thing or another?
Hi all, I'm making a sheet that references another sheet to get data for a detailed graph. I'm trying to count the total number of small, medium, and large projects. The formula I have that works for individual campuses is as follows: =COUNTIFS({Size}, CONTAINS("Small", @cell), {Campus}, CONTAINS("Example", @cell), {In…
-
Not counting based on multiple factors
I'm building a formula that uses the contents in a cell to effect a percentage. Basically: =(count all cells within a range with the word "PASS") (divide this number by) (All the cells within same range that are NOT blank ) The piece of the formula that looks at the row and avoids blank cells looks like this:…
-
Apply logic to document upload in Form
I would like a feature where the "logic" pathways can be applied to the Document Upload field in a form. For example, when you upload a document, the logic allows additional questions/texts to become visible. Essentially certain aspects of a Form would only become visible after a document is uploaded.
