Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here
Sep 01, 2021 06:21 AM
I am trying to check to see if the Date column is empty, then if not, display the date’s weekday in the Day of Week column.
Here’s my formula in the Day of Week column:
IF({Date}!=BLANK(),DATETIME_FORMAT({Date},'dddd'),"")
I do not understand why I am getting errors for all the blanks. I’ve tried several different versions of the formula above. Any help appreciated.
Solved! Go to Solution.
Sep 01, 2021 07:01 AM
Hi Amanda. Even when your date field looks empty, it is not BLANK(). Replace…
IF({Date}!=BLANK()...
with
IF({Date}...
Sep 01, 2021 07:01 AM
Hi Amanda. Even when your date field looks empty, it is not BLANK(). Replace…
IF({Date}!=BLANK()...
with
IF({Date}...