If formula

I have a form in smartsheet which has multiple tabs along with DIVISION. Issue is Crew members are entering the wrong division when they audit the data.

My question is how do i add a division description box above the division tab? to give crew members idea about what division they fall in? and when ever a crew member selects a specific division in the form only the asociated areas should pop up?

* the smartsheet is updated manually. The division description should be automaticaaly updated in the smartsheet when we select the division. How do i do it?

I have tried to put in this formula for Divivion desc to update automatically when division is selected in the smartsheet but no luck -

=If(OR[Division]@row=" West","construction" ,

If(OR[Division]@row= "East"(),"Line services "

If(OR[Division]@row= "North"(),"Power" )))

Appreciate the help

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

You don't need the OR functions or the open/closed parenthesis sets after "East" and "North".

Reddy

Hi Paul,

Thanks for the response, however when I try to follow the steps you put in. I am getting the UNPARSEABLE IN THE DIVISION DESC column. I have attached the images for reference.

Appreciate the help

Paul Newcome

Try removing the square brackets. They are not needed for your column names in this instance and the one has them placed incorrectly.

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.