Formula Help to Set up Sprints

mstanton

I am using this formula to set the sprints in my project plan but get the error "your formula syntax isn't quite right". Looking for help in what I am missing. Thanks

= IF(AND( [End Date]@row > DATE(2024, 11, 27), [End Date]@row < DATE(2024, 12, 10)), "Sprint1", IF(AND([End Date]@row >DATE(2024, 12, 11), [End Date]@row<DATE(2024, 12, 24)), "Sprint2", IF(AND([End Date]@row>DATE(2024, 12, 25),[End Date]@row<DATE(2025, 01, 07)), "Sprint3", "IF(AND([End Date]@row > DATE(2025, 01, 08), [End Date]@row < DATE(2025, 01, 21)), "Sprint4", IF(AND([End Date]@row > DATE(2025, 01, 22 ), [End Date]@row < DATE(2025, 02, 04)), "Sprint5", IF(AND([End Date]@row > DATE(2025, 02, 05), [End Date]@row < DATE(2025, 02, 18)), "Sprint6", IF(AND([End Date]@row > DATE(2025, 02, 19), [End Date]@row < DATE(2025, 03, 04)), "Sprint7",")))))))

Carson Penticuff

I found some misplaced quotation marks, see if this works better:

=IF(AND([End Date]@row > DATE(2024, 11, 27), [End Date]@row < DATE(2024, 12, 10)), "Sprint1", IF(AND([End Date]@row > DATE(2024, 12, 11), [End Date]@row < DATE(2024, 12, 24)), "Sprint2", IF(AND([End Date]@row > DATE(2024, 12, 25), [End Date]@row < DATE(2025, 01, 07)), "Sprint3", IF(AND([End Date]@row > DATE(2025, 01, 08), [End Date]@row < DATE(2025, 01, 21)), "Sprint4", IF(AND([End Date]@row > DATE(2025, 01, 22 ), [End Date]@row < DATE(2025, 02, 04)), "Sprint5", IF(AND([End Date]@row > DATE(2025, 02, 05), [End Date]@row < DATE(2025, 02, 18)), "Sprint6", IF(AND([End Date]@row > DATE(2025, 02, 19), [End Date]@row < DATE(2025, 03, 04)), "Sprint7", "")))))))

Michelle Choate 2

You have an extra " after Sprint 3. So the correct formula is:

=IF(AND([End Date]@row > DATE(2024, 11, 27), [End Date]@row < DATE(2024, 12, 10)), "Sprint1", IF(AND([End Date]@row > DATE(2024, 12, 11), [End Date]@row < DATE(2024, 12, 24)), "Sprint2", IF(AND([End Date]@row > DATE(2024, 12, 25), [End Date]@row < DATE(2025, 1, 7)), "Sprint3", IF(AND([End Date]@row > DATE(2025, 1, 8), [End Date]@row < DATE(2025, 1, 21)), "Sprint4", IF(AND([End Date]@row > DATE(2025, 1, 22), [End Date]@row < DATE(2025, 2, 4)), "Sprint5", IF(AND([End Date]@row > DATE(2025, 2, 5), [End Date]@row < DATE(2025, 2, 18)), "Sprint6", IF(AND([End Date]@row > DATE(2025, 2, 19), [End Date]@row < DATE(2025, 3, 4)), "Sprint7")))))))

mstanton

Thank you so much!!! Works Great!