Using a date range to define a planned Sprint name

I want to use a Start Date to determine which sprint a ticket will be identified with.

For example Sprint 17 starts on 08/13/25 and ends on 08/27/25.

If my Start Date is within this range then I want to output the Sprint Name into a Planned Sprint column.

=IF(([Start Date]@row >= "8/13/25", IF(AND)([Start Date]@row <= "8/27/25"), [Planned Sprint]@row , "2025 DevMo Sprint 17", 0)

Resulted in #UNPARSEABLE

Find more posts tagged with

Sheets

Formulas

Accepted answers

AravindGP

Hi @Stephan Paul

When you use quotes, Smartsheet takes it as a string (text) instead of a date. Hence the error. Try this.

=IF(AND([Start Date]@row >= DATE(2025, 8, 13), [Start Date]@row <= DATE(2025, 8, 27)), "2025 DevMo Sprint 17", 0)

When you apply this formula in the Planned Sprint column, it will update the value 2025 DevMo Sprint 17 if the condition matches or update it with a 0 when it doesn't. Ideally, I would have date ranges for each sprint and reference it in the formula instead of adding static dates as in the above formula.

All comments

AravindGP

Hi @Stephan Paul

When you use quotes, Smartsheet takes it as a string (text) instead of a date. Hence the error. Try this.

=IF(AND([Start Date]@row >= DATE(2025, 8, 13), [Start Date]@row <= DATE(2025, 8, 27)), "2025 DevMo Sprint 17", 0)

Stephan Paul

That did it!

Thank you!

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.