Index and Match with Today functions in a formula

Hello all,

Reaching out because I have been trying to build a formula for a sheet summary field, and have had no success. I have seen a lot of smart people on here figure out similar problems, so I believe someone has the answer for me.

Basically, I am trying to create an index and match formula that automatically looks for "today" to match with. I have tried several different configurations, and keep getting unparseable.

Is this even possible?

Thank you,

Answers

  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭

    Hi @Josh Salvador

    Hope you are fine, Please add a copy of your sheet or a screenshot (after removing or replacing any sensitive information). This will make it easier for me to provide the appropriate answer to your question.

    PMP Certified

    [email protected]

    ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"

  • Genevieve P.
    Genevieve P. Employee Admin

    Hi @Josh Salvador

    The structure of an INDEX(MATCH is as follows:

    =INDEX([Value to Return]:[Value to Return], MATCH("Value to Match", [Column to Match]:[Column to Match], 0))


    So in your case, something like this:

    =INDEX([Value to Return]:[Value to Return], MATCH(TODAY(), [Date Column]:[Date Column], 0))


    If this hasn't helped or you're still receiving an error, I agree with Bassam that it would be helpful to see screen captures of your sheet and the formula you're currently using, but please block any sensitive information.

    Cheers!

    Genevieve

  • @Bassam Khalil and @Genevieve P. ,

    Thank you so much for your help. This worked perfectly. I appreciate the support.


    Sincerely,

    Josh

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!