Using nested IF(AND) with ISBLANK and NOT(ISBLANK)


I seem to have stumped myself. I have a dataset where we enter each date value in a separate column (drafting gets a date, when the document starts routing that gets a date in a different column, when the document is issued that gets a date in yet another column), like shown below.

I would like to figure out a way to have a separate column that summarizes all of that--ideally one that says (at minimum) "drafting," "routing" or "issued"--so in this example rows 47-50 would say "issued," while row 42 would say "routing" and row 43 would say "drafting" or "draft review."

Is there a way I can do that with MAX and MATCH or INDEX and have the max value in a given row report the column name?

Alternatively I was trying to set up a nested IF(AND function using ISBLANK and NOT(ISBLANK) (ie, if issued is not blank it's issued, if issued is blank but routing is not blank it's routing, etc. This is what I attempted (to set up the "routing" value) but it's showing as unparseable and I can't quite figure out where I've gone wrong.

=IF(AND(ISBLANK(Issued@row), NOT(ISBLANK(Routing Start Date@row))), "ROUTING")

Is there a simpler way to do this and I'm overthinking it?

Thank you in advance for any help you can give!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!