Multiple Criteria Formula - Metric Sheet
I am looking for a formula to calculate the number of APPROVED projects with Technology Impact. I am able to get the number of all projects with technology impact, but cannot figure out the second part of the formula to only include APPROVED projects.
Current formula which includes information from the Technology Impacted column: =COUNTIF({Tech Impacted}, "<>NA")
Need additional help with the Approved column to only include projects "Approved".
This is the sheet data is being pulled from into the Metric Sheet. Thank you for any help.
Best Answers
-
Try changing to Countifs, and update the name of the approved range column:
=COUNTIFS({Tech Impacted}, <> "NA", {Approved Range}, "Approved")
-
It shouldn't as long as your cross-sheet range matches. I do see an extra closing parathesis in your formula that will cause issues:
{Approved/Declined}), "Approved")
That bold one is closing off the formula too soon.
But I see it's been removed when you revised it again.
Answers
-
Try changing to Countifs, and update the name of the approved range column:
=COUNTIFS({Tech Impacted}, <> "NA", {Approved Range}, "Approved")
-
When I do that:
=COUNTIFS({Tech Impacted}, <>"NA", {Approved/Declined}), "Approved")
I get an #Unparseable. Is that because there is a "/" in the reference?
-
That was the problem! When I change the column title it worked! Thank you :)
=COUNTIFS({Tech Impacted}, <>"NA", {Approved Status}, "approved")
-
It shouldn't as long as your cross-sheet range matches. I do see an extra closing parathesis in your formula that will cause issues:
{Approved/Declined}), "Approved")
That bold one is closing off the formula too soon.
But I see it's been removed when you revised it again.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 455 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!