Date Formula Not Working?

I am trying to auto-populate some dates in my "Due Date" column. When a date is entered in row 5, I need row 6 to be "date" - 5 days. The formula I tried was:

=[Due Date]5 - 5

But when I click enter, it just adds a " ' " to the beginning and displays the formula. Am I missing something?

*Note, this is when using a date column from a timeline template. If I create a new date column on a blank smartsheet the formula works.

Screenshot 2025-06-04 at 2.19.56 PM.png

Find more posts tagged with

Formulas

dates

update column

Accepted answers

All comments

Darren Mullen

@Sam_33 It looks like that Due Date column is part of a project plan, which means you can't put a formula there.

Due date will be driven by duration and the start date

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.