Adding to dates without a formula
Hi folks.
So, today I discovered that if you are in a date column and type "+1" then it creates a date 1 day from today, and if you type "+15w" it creates a date 15 weeks from now.
If you just type "16w" you get the 16th week of the current calendar year.
What I'd like to do though is be able to type ON TOP of an existing date and have it add to THAT date. I can't find the syntax for this. I've tried "++" and "=+" but these don't work.
It seems odd that the options above are covered but adding to the date in the cell isn't covered.
thanks in advance
Ed
Best Answer
-
Hi @Jeff Reisman , thanks but it isn't formulae I'm looking for - it's features with which my users can interact with their project management tools.
I'll leave a suggestion for Smartsheet, because it would enhance the existing functionality to be able to add to a date in situ, especially in conjunction with a "ctrl+enter" function for bulk entering, like excel. That way you could add, e.g. 9 weeks to all of the start dates in your project without having to export to excel to achieve it (assuming dependencies aren't set).
Answers
-
That's a pretty cool discovery.
However, you can only add days to an existing date value, unless you take the individual date components and do math on those.
For instance, =StartDate@row + 7 will add 7 days to the StartDate.
If you just wanted to add 2 months to the date, you can either approximate it by using =StartDate@row + 60, or you can break the StartDate into it's pieces and rebuild it:
=DATE(YEAR(StartDate@row), MONTH(StartDate@row) + 2, DAY(StartDate@row))
So if your StartDate is 3/14/22, the formula above would return 5/14/22.
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
-
Hi @Jeff Reisman , thanks but it isn't formulae I'm looking for - it's features with which my users can interact with their project management tools.
I'll leave a suggestion for Smartsheet, because it would enhance the existing functionality to be able to add to a date in situ, especially in conjunction with a "ctrl+enter" function for bulk entering, like excel. That way you could add, e.g. 9 weeks to all of the start dates in your project without having to export to excel to achieve it (assuming dependencies aren't set).
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!