On my sheet, I have a Planned Migration Date column that has discrete date values for each row. I have another column called "Migration Week Monday" where it determines Monday's date for the associated Planned Migration Date. My formula works well on the sheet up until I use a cross sheet formula to pull in the date value, and then at that point, it returns empty.
The formula that works when all of the data is local:
=IF(ISBLANK([Planned Migration Date]@row), "", IFERROR(YEAR([Planned Migration Date]@row) + " Week " + WEEKNUMBER([Planned Migration Date]@row), ""))
Becuase it's returning me a blank value, I'm assuming that it's reading the date field now as ISBLANK, but when I run a simple formula to check it, it tells me that it's not blank:
=IF(ISBLANK([Planned Migration Date]@row), "TRULY BLANK", "NOT BLANK")
I've also tried using a helper column set as date value to extract it from a text field wondering if the formula was bringing it back as text, but no luck :
=[Planned Migration Date]@row
I re-wrote my formula to just call back to the reference sheet for the date instead and so I've fixed my column, but now all of my date-based filters, reports, and dashboards are messed up, so I really need to figure out what's happening with this date field. Any ideas greatly appreciated!
