Formulas and Functions

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

If formula

✭✭
edited 03/29/23 in Formulas and Functions

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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions