I have a table were I have a bunch of columns. One of them contains dates (Lookup from another table), and one of them is an IF-formula that should write “Yes” if it is today´s date today and “No” if it is not.
My formula looks like this:
IF(dateField = TODAY(), “Yes”, “No”)
The problem: No matter what date it is today and no matter what the dates are in the dateField, the IF-formula always writes “No” for all records.
What am I doing wrong and how do I fix it?