"GS Bugs/Enhancement summary" sheet in Smartsheet

Options

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

  • Genevieve P.
    Genevieve P. Employee Admin
    Options

    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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!