How to Make a Formula to Count certain "Status"
Options
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!
Answers
-
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?
-
Hi Mike,
Yes, thank you, I will give this a shot.
-
Awesome! Let me know if you have any questions! And be sure to accept my answer if the solutions work! Thanks!
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!