I want the formula to count how many risks there are that are open.
=COUNTIFS([Risk or Issue?]:[Risk or Issue?], "Risk", ([Status], "Open")))
I can't seem to get it to work. Can anyone help?
I hope you're well and safe!
Try something like this.
=COUNTIFS([Risk or Issue]:[Risk or Issue], "Risk", Status:Status, "Open")
Did that work/help?
I hope that helps!
Be safe and have a fantastic week!
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.
Hi @Andrée Starå, thank you that worked.
How about if I had multiple sub components that I wanted to count together also. For example I wanted to count open risks that are from project A, project B and project C?
Can you help?
Happy to help!
Regarding your other question, I'd recommend using a Report, a so-called Master Metrics sheet combined with Cross-Sheet formulas, or Cross-Sheet formulas in one of the sheets.
✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
How do you create a master metric sheet?
©2022. All Rights Reserved Smartsheet Inc.