Function for adding +30 days to a date is adding on 30 onto the end of my year ! (solved)
Molly12345
✭✭
Figured out the completed date column was not set at date, straight after posting. Problem solved!
Hi, we have been using this function below for many year, however I must have accidently hit something and messed it up. It is now adding 30 onto the end. I think it may have happened when I changed the formula to a column formula . Any help would be greatly appreciated !
Thanks in advance 😀
Answers
-
Glad you were able to figure it out.
Smartsheet Community Champion and Ambassador
If my answer helped you, please be sure to mark it as Accepted to help future learners locate the information.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 303 Events
- 34 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!