How do I write a '% Approved' formula for two conditions?
How do I add a second condition of Category = SD to this formula in my Sheet Summary to calculate the % of SD Approved? The first condition is Status = Approved.
=(SUM(COUNTIF(Status:Status, "Approved") / COUNT(Status:Status) * 1))
I know this is probably simple for most, but I'm new to creating Smartsheet formulas.
Thanks in advance!
Chris
Answers
-
If you're trying to get a count of records with status as Approved over the total count, not sure why you have a sum in front of the formula. You can try this and apply the % format in your Sheet Summary field
=COUNTIFS(Status:Status, "Approved", Category:Category, "SD") / COUNT(Status:Status) * 1
Thanks,
Aravind GP| Principal Consultant
Atturra Data & Integration
M: +61493337445
E:Aravind.GP@atturra.com
W: www.atturra.com
-
Thank you, Aravind. I realized I already have reports set up to calculate the percentages and do not need them in the Sheet Summary. I greatly appreciate your response!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!