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
Check out the Formula Handbook template!