Return Column Name using a Formula

bbennett

I have several columns I use to track dates for different steps in a process.  i.e. Ordered, Delivered, Installed.  Is there a formula that will return the column name of the latest date across these columns.

For instance, Ordered = 8/4, Delivered = 8/15, Install = n/a.  In my "Status" column I'd like to return "Delivered" since that's the latest step that has been completed.

Is there a way to do this in Smartsheet?

Mike Wilday

Would you ever have an install date without an order date? Or a delivery date before an order date? If not, use this formula. It checks to see if there is a date in the Install field first, if not - then it checks for a date in the Delivered Date, if not, then it checks ordered. If none of the columns are dates it will be blank. You could put your own text in the final quotes to have a message if you wanted. Also, you need to make sure your column names and number are accurate. I built this based on row 1... update the formula to match. 

=IF(Isdate(install1),"Installed", IF(isdate(delivered1),"Delivered", IF(isdate(ordered1), "Ordered","")))