How to Make a Formula to Count certain "Status"

Josh Black

Hello - I use Smartsheet for my company as a project management tool. I am wanting to set up a few formulas to make seeing open and completed tasks easier at a glance. I would like one to count anything "assigned, or in-progress" and the one to count "completed." Does anyone know how to do this by chance? Thanks!

Mike Wilday

Hi Josh, I would use the following formulas in the sheet summary section and add them to a dashboard.

=COUNTIFS(Status:Status, OR(@cell = "Assigned", @cell = "in-progress")

=COUNTIFS(Status:Status., "Completed")

I am assuming this is tracking tasks or projects in one sheet?

Josh Black

Hi Mike,

Yes, thank you, I will give this a shot.

Mike Wilday

Awesome! Let me know if you have any questions! And be sure to accept my answer if the solutions work! Thanks!