Can I use an If Statement in Dropdown Form?

Benjamin Chua

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...?

 

RossL

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

Benjamin Chua

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

RossL

@Benjamin Chua

you would need a separate column for the formula and the column filled in by the form for Temp would be hidden.