Adding Days to a Date derived from a formula

KNorton

Hi All,

I am trying to add a Follow Up Date to my sheet, following a Submission Date. I tried:

=[Submission Date]@row + 14

and instead of getting a date 14 days in the future, I am just getting the number 14 added at the end of the line.

Both columns are set to Date Types.

The Submission Date is derived from a formula -

Which uses the date captured by smartsheet in the "Created Date" Type column.

Thank you in advance for any tips and advice! 😊

Find more posts tagged with

Formulas

dates

Accepted answers

DKazatsky2

Hi @KNorton,

Most likely, the date in "Submission Date" is probably being treated as a string instead of a date (if you hover the mouse pointer over the value, do you get a date?).

Try changing the "Submission Date" formula to this.

=DATE(YEAR([Created Date]@row), MONTH([Created Date]@row), DAY([Created Date]@row))

Hope this helps,

Dave

Paul Newcome

The LEFT function outs a text string. Assuming [Created Date] is a system generated column that outputs the date / time stamp when a row is created, you could use

=DATEONLY([Date Created]@row) + 14

Paul Newcome

Happy to help. 👍️

All comments

DKazatsky2

Hi @KNorton,

Most likely, the date in "Submission Date" is probably being treated as a string instead of a date (if you hover the mouse pointer over the value, do you get a date?).

Try changing the "Submission Date" formula to this.

=DATE(YEAR([Created Date]@row), MONTH([Created Date]@row), DAY([Created Date]@row))

Hope this helps,

Dave

Paul Newcome

The LEFT function outs a text string. Assuming [Created Date] is a system generated column that outputs the date / time stamp when a row is created, you could use

=DATEONLY([Date Created]@row) + 14

KNorton

Thank you both! Problem solved, I didn't realise that the LEFT function was outputting text.

Paul Newcome

Happy to help. 👍️

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.