Help with writing a status formula

Options
Mary Vogt
Mary Vogt ✭✭✭✭✭

Hi, I am trying to use a Status column to show the status of these criteria:

If [25-Hour Training] is blank and [5 Hour Training] is blank = red


If [25-Hour Training] is blank and [5 Hour Training] is not blank = yellow


If [25-Hour Training] is not blank and [5 Hour Training] is not blank = green

using a separate metrics sheet I have linked to the Status column. I am not sure if I need to use the COUNTIFS function, or otherwise. Can someone point me in the right direction? Thank you!

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!