I have a "helper" column with the Column Type of Date and I want to use an IF formula to return a date. However, I only get "#UNPARSEABLE" errors regardless of what I've tried. I have the "Restrict to dates only" checkbox un-checked because I get the error whether it's checked or not... Here is the formula:
=IF([Project IT Department]@row = "Supply Chain Systems", [Project Start Date]@row, "")
Seems pretty basic, I'm not referencing another sheet, just comparing one column of the row and picking a date column if true. My concern is that the IF function is comparing a text value and then returning a date but a true function should be agnostic about the data types. What is causing the error?