Help with writing a status formula

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!

Paul Newcome

Try something like this...

=IF([25-Hour Training]@row = "", IF([5 Hour Training]@row = "", "Red", "Yellow"), "Green")

Paul Newcome

It depends on exactly what you want to show and how, but yes. The output itself can be used in a Metrics Widget on a Dashboard.

Paul Newcome

Happy to help! 👍️

Paul Newcome

Try something like this...

=IF([25-Hour Training]@row = "", IF([5 Hour Training]@row = "", "Red", "Yellow"), "Green")

Mary Vogt

That worked perfectly. Thank you! Will this allow me to use it as a metric in a dashboard?

Paul Newcome

It depends on exactly what you want to show and how, but yes. The output itself can be used in a Metrics Widget on a Dashboard.

Mary Vogt

Thank you again!

Paul Newcome

Happy to help! 👍️