"GS Bugs/Enhancement summary" sheet in Smartsheet

Alexisss

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"?

Genevieve P.

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