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
- 64.9K Get Help
- 441 Global Discussions
- 140 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!