I have added a “Year” column to my transaction sheet as discussed in this article - https://help.tillerhq.com/en/articles/1118975-add-year-data-to-your-tiller-spreadsheet
Unfortunately, I am getting an error with some of the rows (Function YEAR parameter 1 expects number values. But ‘07/27/2020’ is a text and cannot be coerced to a number.) and the year does not populate. I have double checked the formatting of column B and it is formatted as Date MM/DD/YYYY (not text as the error suggests)
How do I go about correcting this?
Thanks for your help