How do I write a '% Approved' formula for two conditions?

Chris M Johnson

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

AravindGP

Hi @Chris M Johnson

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

Chris M Johnson

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!