Index/Match formula?

Hi! I'm trying to create a formula on the Sheet Summary that allows me, based on the Sprint number, to retrieve Start Date and End Date.

I've tried to use =INDEX(([Start Date]:[Start Date]), MATCH([Actual Sprint]#, [Sprint #]:[Sprint #])) but it's giving a No Match error.


Best Answer

  • Kelly Moore
    Kelly Moore ✭✭✭✭✭✭
    Answer ✓

    Hey Gabriela

    I just tested the formula in my sheet and it works.

    What is the formula that is gathering the Actual Sprint, and how is the Sprint # inserted. Try this

    =INDEX([Start Date]:[Start Date], MATCH(VALUE([Actual Sprint]#), [Sprint #]:[Sprint #],0))


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!