How to summarize current status organized by column

Tracy.Kenna

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!

Paul Newcome

I would use a nested IF statement.

=IF([Information Received]@row = "", "Awaiting Information", IF([Start Date]@row = "", "Awaiting Start", IF([Draft TO Scientist]@row = "", "Awaiting Draft To Scientist", IF(...........................................

Paul Newcome

I would use a nested IF statement.

=IF([Information Received]@row = "", "Awaiting Information", IF([Start Date]@row = "", "Awaiting Start", IF([Draft TO Scientist]@row = "", "Awaiting Draft To Scientist", IF(...........................................

Tracy.Kenna

Thank you! I will try that.

Paul Newcome

Happy to help. 👍️