Rolling up RYG status by workstream

Hello,

I'm looking to write a formula that averages my health status, but by the workstream column. For example, in the screenshot below, I'm looking at the "Equipment and Technology" workstream. I am using a separate metrics sheet to write the formula, as there will be one roll up status for each of my workstreams (Equipment and Technology; Construction; Operations; etc.). I will then use the roll up RYG for each workstream as metric widgets in my dashboard.

I'm not super picky on what creates a yellow or red status, so it can be pretty general. I've seen community discussions on how to write a formula to create a rollup RYG, but I'm not sure how to incorporate the Workstream criteria.

Thanks!

Find more posts tagged with

Formulas

Dashboards

Project Management

Accepted answers

All comments

Paul Newcome

You would include the workstream range/criteria set inside of the COUNTIFS that evaluate the RYG column

COUNTIFS({RYG}, @cell = "Red", {Workstream}, @cell = "Equipment and Technology")

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.