How to show most frequent status per unique groupings?

yh374

Hi,

So I have the following sheet set up for projects where each Group may have more than one project in different statuses:

The order of status are the following: 1) Started, 2) In Progress and 3) Completed. I am trying to set up a formula that will return the most frequently populated Status per unique Group and also looks to return the highest ranked status if it's stuck between two Status values. Something like this:

So for example, since Group 1 has more projects with "In Progress Status", I want "In Progress" to show up as Overall Status. And since Group 2 has only two projects in different status, I want to return the highest ranked status between the two, which is "Completed."

Is there a possible formula or workaround to do this?

Thank you for any ideas and help!

vh.

Hi @yh374 It appears your question might have already been addressed here:

https://community.smartsheet.com/discussion/29101/conditional-formatting-one-rule-on-multiple-columns

Additionally, this may be helpful:

https://help.smartsheet.com/articles/2482629-manage-conditional-formatting-rules

-

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

yh374

Hi vh.,

That did not answer my question; I am not looking for a conditional formatting rule. I am looking to be able to return a frequent value (a mode) for each unique group. Thanks!