Last Entered Value

Options

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 ✓
    Options

    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.

    =MAX([36-Month]@row:[60-Month]@row)


    The formula for adding 6 months should work though.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!