90 Days Prior to a Target Date Formula
Hi There,
I've reviewed the forms and found a formula that seems to work for everyone but me:
=[Target Submit for Comment Date]@row - 90
I get Invalid Column Value error.
I just need to calculate 90 days before a specific date - how would I go about doing that?
Thanks!
Best Answers
-
If you go to "Column Properties" of the column where your formula is and change the type to "Date", this formula should work just fine (it did for me a few minutes ago).
-
Here is a screen capture of the process.
Answers
-
If you go to "Column Properties" of the column where your formula is and change the type to "Date", this formula should work just fine (it did for me a few minutes ago).
-
Here is a screen capture of the process.
-
THANK YOU!!
-
@Blake Neyland , how about if I wanted to use the above formula but not for the entire column just the ones that are marked as "New" in the another column?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!