"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

Unknown

This content has been removed.

Unknown

This content has been removed.

ameliamax

The GS Bugs/Enhancement Summary sheet in Smartsheet is an excellent tool for tracking and prioritizing issues and improvements. To make it even more effective, consider adding a column for "Impact Level" (e.g., High, Medium, Low) to help prioritize tasks based on their urgency and effect on users. Additionally, integrating automated reminders for upcoming deadlines or stale tasks could further streamline the workflow. Great work on maintaining such a detailed and organized system!