Skip to main content
Solved

If statement with date - Error on blank cells

  • September 1, 2021
  • 1 reply
  • 37 views

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.

Best answer by augmented

Hi Amanda. Even when your date field looks empty, it is not BLANK(). Replace…

IF({Date}!=BLANK()...

with

IF({Date}...

1 reply

Forum|alt.badge.img+18
  • Inspiring
  • Answer
  • September 1, 2021

Hi Amanda. Even when your date field looks empty, it is not BLANK(). Replace…

IF({Date}!=BLANK()...

with

IF({Date}...