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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!