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
Answers
-
You don't need the OR functions or the open/closed parenthesis sets after "East" and "North".
-
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
-
Try removing the square brackets. They are not needed for your column names in this instance and the one has them placed incorrectly.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.9K Get Help
- 474 Global Discussions
- 207 Use Cases
- 517 Announcements
- 5.5K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 83 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!