IF/Then Using Color Status

Options

Hello,

I am trying to figure out a formula to signal the following = if the status is red, then same row under the data column should populate to the number 1, if status is yellow, then the same row under the data column should populate to the number 2, etc.

I have no idea where to start...help!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!