"GS Bugs/Enhancement summary" sheet in Smartsheet

For each row in your "GS Bugs/Enhancement summary" sheet in Smartsheet, do you want to calculate and display the following information for entries categorized as "Enhancement":

  1. Quantity of entries marked as "Complete"?
  2. Quantity of entries marked as "Not Complete"?
  3. Percentage of entries marked as "Complete" out of the total entries categorized as "Enhancement"?

Answers

  • Hi @Alexisss

    You can use formulas to create calculations. For example, a COUNTIFS function will count how many rows meet your criteria.

    So, if you have "Complete" or "Not Complete" as a column titled STATUS, then you can use a formula like so:

    =COUNTIFS(Status:Status, "Complete")

    And then again for your next criteria:

    =COUNTIFS(Status:Status, "Not Complete")

    For a percentage, find the total entries that are both "complete" and "enhancement" and divide it by the "enhancement" total:

    =COUNTIFS(Status:Status, "Complete", Category:Category, "Enhancement") / COUNTIFS(Category:Category, "Enhancement")

    Keep in mind you need to adjust the column names to match your column names. If this hasn't helped, it would be useful to see a screen capture of your sheet with the column names, but please block out sensitive data.

    Thanks,
    Genevieve

    Join us at Smartsheet ENGAGE 2024 🎉
    October 8 - 10, Seattle, WA | Register now

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!