Date Formula Not Working?

Sam_33

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

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