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

$C:\Users\bchua\AppData\Local\Temp\msohtmlclip1\01\clip_image002.jpg$

$C:\Users\bchua\AppData\Local\Temp\msohtmlclip1\01\clip_image004.jpg$

Find more posts tagged with

Accepted answers

All comments

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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.