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

  • RossL
    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

  • 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
    RossL ✭✭✭✭✭✭
    edited 06/24/20

    @Benjamin Chua

    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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!