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

  • AravindGP
    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

    Thanks,

    Aravind

    Reach out for any help on licenses, configuration, or training

  • 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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!