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

    bassam.khalil2009@gmail.com

    ☑️ 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"

  • 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

    Need more help? 👀 | Help and Learning Center

    こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions

  • @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!