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

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.

Andrée Starå

Hi @Geraldine

I hope you're well and safe!

I've requested access.

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Geraldine

Hi,

A colleague of mine helped me with the formulas.

Andrée Starå

@Geraldine

Excellent!

Glad you got it working!

✅Please support the Community by marking your post with the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Geraldine

Hi, I used the =COUNTIFS