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.
Best Answers
-
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.
-
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 + ""
Answers
-
Is your column type set to Date?
-
Hi @Paul H - Yes the column type is set to Date.
-
It is set to date.
And I used this formula:
And I am getting this error:
"Invalid Column Value"
-
Is the +Days column also of type Date?
-
@David Tutwiler - No, it's not. That's just the "3" days. It's (Text/number).
-
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.
-
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 + ""
-
@David Tutwiler - It worked, thank you! I had to change the Reminder column to "Date".
-
@Paul H Thank you!
-
Great to hear Deesa.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 439 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 67 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!