Last Entered Value


Good morning gurus!

I have another puzzle for you. I have several date columns that may or may not be filled out depending on the project (row). I need to calculate a date for 6 months beyond the last entered value in the date columns (see pic below). Any suggestions?

Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    Slight adjustment to @Leibel S's first formula. In that formula, the COUNT is generating a number for the row number and not the column number.

    =INDEX(COLLECT([36-Month]@row:[60-Month]@row, [36-Month]@row:[60-Month]@row, @cell <> ""), 1, COUNT([36-Month]@row:[60-Month]@row))

    I personally would just use a MAX function for this one.


    The formula for adding 6 months should work though.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!