I need to add days to a date with a formula.
I use the formula: =Procedure8+35 and it will calculate 35 days from procedure with the correct date. If I ask it for +76 days I will get #INVALID COLUMN VALUE. Not sure what I am missing.
Procedure is the column and 8 is the row where the date is calculated from.
Best Answers

I just tested it with 76 and it works for me. Are you doing this calculation in a different column than with 35? If so you should verify that it is a Date column and not a Text/Number Column.

Are you able to provide some screenshots for context? Are you putting two separate formulas into two separate columns, or are you updating the working formula with just a different number of days?
It almost sounds to me as if you are putting in two separate formulas into two separate columns, and the one that is throwing the error is not set as a date type column.
Answers

I just tested it with 76 and it works for me. Are you doing this calculation in a different column than with 35? If so you should verify that it is a Date column and not a Text/Number Column.

Are you able to provide some screenshots for context? Are you putting two separate formulas into two separate columns, or are you updating the working formula with just a different number of days?
It almost sounds to me as if you are putting in two separate formulas into two separate columns, and the one that is throwing the error is not set as a date type column.

Thank you all for responding. I did not have the column set to Date it was Text. Working, like it should now.

Happy to help. 👍️
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.1K Get Help
 349 Global Discussions
 199 Industry Talk
 427 Announcements
 4.4K Ideas & Feature Requests
 133 Brandfolder
 127 Just for fun
 127 Community Job Board
 455 Show & Tell
 28 Member Spotlight
 1 SmartStories
 282 Events
 36 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!