Return Sprint based on finish date
I have a project schedule where I am tracking activities. I would like to return a sprint number in column "Sprint" based on the finish date. Example: Sprint 1 is 6/23 - 7/6 and the task ends 6/29 so I would like the column to return a value of "Q1 Sprint 1" I have set up a separate sheet with the Sprints and start/finish dates but not sure if that is the best method. Any recommendations on how to build this formula?
Help Article Resources
Check out the Formula Handbook template!