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
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.3K Get Help
 361 Global Discussions
 199 Industry Talk
 427 Announcements
 4.4K Ideas & Feature Requests
 136 Brandfolder
 127 Just for fun
 128 Community Job Board
 444 Show & Tell
 28 Member Spotlight
 1 SmartStories
 283 Events
 35 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!