Unlike some other spreadsheet programs, Smartsheet formulas cannot reference the actual header row (row 0) as data.
I have a sheet which tracks many dates pertaining to our projects. Each column is named for the relevant milestone. I built a column formula that can iterate over those columns and pull the most recent date before today—i.e. the most recently completed milestone for that record.
I would like to create another column which can return the name of the most recently completed milestone. However, I am unable to pull in the names of the columns. If I could pull the column names in, I would be able to create trackers in Smartsheet that are much more useful to leadership at my workplace.
Please share other use cases where it would be helpful for you to be able to pull and return column names as data!
