How to Make a Formula to Count certain "Status"


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!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!