return date which is next higher one


I'm looking for a formula to check the "End date" and return the next higher from date from the reference sheet.

e.g. End Date is May 7, the result should be Pre-confirmed 90 LT=May 8

or End Date is June 16, the result should be Pre-confirmed 90 LT=June 26

I have no idea which formula could work.

Thanks for your help!

Best Answer

  • Nick Korna
    Nick Korna ✭✭✭✭✭✭
    Answer βœ“

    Hi @Christine Menke,

    A formula like this should work:

    =INDEX([Pre-confirmed 90 LT]:[Pre-confirmed 90 LT], MATCH([End Date]@row, [Pre-confirmed 90 LT]:[Pre-confirmed 90 LT]) + 1)

    Some example data:

    Hope this helps, but if you've any problems/questions, then just post! πŸ™‚


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!