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
 61.2K Get Help
 321 Global Discussions
 197 Industry Talk
 415 Announcements
 4.2K Ideas & Feature Requests
 126 Brandfolder
 153 Just for fun
 124 Community Job Board
 441 Show & Tell
 26 Member Spotlight
 1 SmartStories
 277 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!