I want to create a cell that will report the # of Status "Complete" If the value in an other column

Geraldine
Geraldine âś­âś­âś­

Hi,

I would like to create a summary sheet ((29) GS Bugs/Enhancement summary - Smartsheet.com) .

I want to display the quantity of "Complete" from the value Enhancement.

Same with "Not Complete" from the value Enhancement

And then the % of Complete from the value Enhancement

and then for each row.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!