How to summarize current status organized by column

Apologies for the silly question, but I can't figure out the best way to summarize or report what I need here and hoping from advice from more experienced users.

We record the dates we completed parts of a project in columns (start date, draft review, issued, etc). I'd like to figure out a way to easily report where projects are in a simple summary (ie, Projects D,E and F are routing but not issued; projects G, H and I are out for draft review, etc). I'm open to doing this via report, via sheet summary, via color coding/if then statment, but I'm not entirely sure where to start. Can anyone point me to some resources to help me set this up? Thank you very much!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!