what is the formula to collect Sprint no, based on the start date for a task from another sheet


I'm trying to use =INDEX(COLLECT({Project PI & Sprint-Primary Column}, {Project PI & Sprint-Start Date}, <=[Start Date]@row), {Project PI & Sprint-End Date}, >=[End Date]@row, 1) but its not working

I want to add a formula in this sheet to provide Sprint # based on the start and end date for the task, refrencing to another sheet with all set dates for each sprints

the reference sheet to collect the data from is below:



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!