Date Column Formula

JerriD_22

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!

Error.docx

See attached image. I appreciate your help.

JerriD_22

Paul,

That worked! I didn't realize it, but the column heading did have an extra space. I appreciate you bringing that to my attention!

Paul Newcome

Happy to help. 👍️

When you are writing out any formula (as long as it is valid), cell references should be highlighted some kind of color. When it is black like the rest of the other text, that means the column name is not recognized as one being on the sheet. Since the text appears to match based on your screenshot, the extra space bit was the first thing I thought of.

Kevin Smith

Hi,

Can you paste a screen shot. It's probably not a good idea to open a .docx.

Thank you

Paul Newcome

Double check that the column name is spelled exactly correct in the second sheet. It may be that the column name has a second space in it. While a second space is stored on the back end, it will not be visible.

All of these words have 5 spaces between them .

But all of these words have 1 space between them.

JerriD_22

Paul,

That worked! I didn't realize it, but the column heading did have an extra space. I appreciate you bringing that to my attention!

Paul Newcome

Happy to help. 👍️

When you are writing out any formula (as long as it is valid), cell references should be highlighted some kind of color. When it is black like the rest of the other text, that means the column name is not recognized as one being on the sheet. Since the text appears to match based on your screenshot, the extra space bit was the first thing I thought of.