Can I use an If Statement in Dropdown Form?
I have Column Field "Office Location" Single Dropdown NYOffice / NJOffice / CTOffice / WFH
I also have Column Field "Temp" = Text/Number
My Question:
If column field “Office Location” = WFH, then column field “Temp” = value to WFH or Zero “0”, in other words, if value selected in Office Location = WFH, make the Temp value = to WFH or 0 (zero)
Which is this in smartsheet =IF([Office Location]@row = "WFH", "WFH")
*** I would like to default to WFH in Temp if WFH is selected***
How do I apply this to the Form? Where People entering their Body Temperature as different Value like 97.7 etc...?
Answers

there is not a way to add this type of logic in the form that I am aware of. What I would do is add a column with the formula =IF([Office Location]@row = "WFH", "WFH",Temp@row). Then you could use the form logic to not show the temp field if WFH is selected for the location

The Office Location Column is a dropdown
The Temp Column is Text/Number
Where would you like me to add the formula? in Temp or Office Location? I add the formula in Temp and it gave me a #circular reference error

you would need a separate column for the formula and the column filled in by the form for Temp would be hidden.
Help Article Resources
Categories
Check out the Formula Handbook template!