Add or subtract Dates in Smartsheet

Hi All,

I am trying to add a field where I can add 3 days to the end date column. For example the end date is 01/23/23 and I need to add 3 days to this in a new column. So the formula I used is =[end date]@row + 3. When I do this, I am getting the following error:

"Invalid Column Value"

Can someone tell me what I need to do to fix this?

I need this column to use it for automation in order to send email reminders after 3 days of the end date.

Thanks so much for your help in advance! Look forward to hearing from you.

Find more posts tagged with

Accepted answers

David Tutwiler

Understood. Both the original date and the reminder date columns have to be set to date. The only thing I can think of that would cause this error is the reminder date column is not set to a Date type.

Paul H

Change the 3 days to date format or If you want it to be just text/number then add some quotes

= [End date of requested leave time]@row + 3 + ""

All comments

Paul H

Is your column type set to Date?

Deesa Dontamsetti

Hi @Paul H - Yes the column type is set to Date.

Deesa Dontamsetti

It is set to date.

And I used this formula:

And I am getting this error:

"Invalid Column Value"

David Tutwiler

Is the +Days column also of type Date?

Deesa Dontamsetti

@David Tutwiler - No, it's not. That's just the "3" days. It's (Text/number).

David Tutwiler

Paul H

Change the 3 days to date format or If you want it to be just text/number then add some quotes

= [End date of requested leave time]@row + 3 + ""

Deesa Dontamsetti

@David Tutwiler - It worked, thank you! I had to change the Reminder column to "Date".

Deesa Dontamsetti

@Paul H Thank you!

David Tutwiler

Great to hear Deesa.

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.