-
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.
-
Help with collect formula with multiple AND arguments
Hi folks, I am currently using this formula, which works fine: =IFERROR((AVG(COLLECT({#Working Days to Kickoff with KP}, {Verizon Received Date}, AND(@cell <= DATE(2023, 1, 31), @cell >= DATE(2023, 1, 1))))), "") This gives me the average time we take to kick off our projects from the date we receive our projects from the…
-
Logic in Forms RE: Max/Min Date Conditions
I am trying to build a form that is for tuition reimbursement applications. By policy- applications cannot be received either 30 days before OR after the semester start date. I have a pop up message built into the logic to appear if one of those conditions are met. However, I can get only ONE to work, but not both built…
