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
Check out the Formula Handbook template!