Return Header Based on Last Column Populated

I'm trying to figure out a formula to add a date to a particular cell, then return the 'header' value in another cell. Ideally it's a formula automated to find the last populated cell of a row, then return the 'header' of that column.

Sample situation: with the 4/1 date populated here, I want the empty green cell to read as "Mar". If the last populated cell was the 3/28, though, the empty green cell would read "Feb".

Is this possible?

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!