Status Circle Automation

Hi, I am using status circles for a high level status report. Is it possible to automate the 'Overall' Status Circle based on the colors in the other measures (budget, timeline, scope, KPIs, value). For example, if 4-5 of the metrics are green, Overall is green. If 3/5 are green, Overall is Yellow. If 1-2 are green, Overall should be red. etc

There's many different scenarios, so is there an efficient way to capture all of this instead of an IF statement?

Find more posts tagged with

Sheets

Formulas

Reports

Project Management

Accepted answers

All comments

L_123

Not really, but you can make a somewhat efficient if statement.

=if(countif(overall@row:value@row,"Green")>3,"Green",if(countif(overall@row:value@row,"Green")=3,"Yellow","Red"

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.