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! 😊

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

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.