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, 11), [End Date]@row DATE(2024, 12, 25),[End Date]@row DATE(2025, 01, 08), [End Date]@row DATE(2025, 01, 22 ), [End Date]@row DATE(2025, 02, 05), [End Date]@row DATE(2025, 02, 19), [End Date]@row < DATE(2025, 03, 04)), "Sprint7",")))))))

Formula Help to Set up Sprints

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",")))))))

Find more posts tagged with

Accepted answers

All comments

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!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.