How can i make an automation to notify me 2 years before a due date?

Luka

I have a due date (e.g. 28/10/2027) and id like to be notified 2 years before the date. As smartsheet only allows me to set an automation 365 before a due date, I made a helper column which would bring back the date i should be notified. I used the formula below but i get an error.

=DATE(DAY([Due Date]@row), MONTH([Due Date]@row), YEAR([Due Date]@row) - 2))

Can someone please help?

Paul Newcome

Make sure both columns are formatted as date type columns.

MarceHolzhauzen

Hi @Luka

It looks like you have an extra bracket at the end of your formula.

Also, double check the sequence of the DAY MONTH YEAR

I believe your formula should be:

=DATE(YEAR([Due Date]@row) - 2, MONTH([Due Date]@row), DAY([Due Date]@row))

Luka

Thanks, for some reason i am now getting the #INVALID COLOMN VALUE error even though my column name matches what is in my formula?

Paul Newcome

Make sure both columns are formatted as date type columns.