Date Column Formula

I am attempting to use the formula: =[date]@row - 14. I want the date in my Approved By column (it is formatted as a date column) to populate 14 days earlier than the date in my UG POJ column (also a date column). The actual formula I am using in the Approved By column is:

=[UG POJ]@row - 14

When I test it on my test sheet, it works great. However, when I try it on my actual sheet, it gives me the UNPARSEABLE error. I'm wondering if it would have something to do with some other setting on the sheet? I cannot figure out what the issue is!

See attached image. I appreciate your help.

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!