Help with writing a status formula

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!

Find more posts tagged with

Accepted answers

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! 👍️

All comments

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! 👍️

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.