Skip to main content
Solved

Need help removing Error from a formula

  • October 18, 2023
  • 1 reply
  • 21 views

Forum|alt.badge.img+1

Hi,

I'm terrible at the formula stuff, but basically I have a Publish Date in my Airtable view for when a piece of content should be published. I want to add the Day of Week as well so we can clear see which post is which day, as well as the actual date (as some gets scheduled a bit further in advance)

The formula I'm using to display the day is:  DATETIME_FORMAT({Publish Date},'dddd')

All I need to do is display nothing if there is no publish date set

Best answer by Databaser

This should work for that:

IF({Publish Date}, DATETIME_FORMAT({Publish Date},'dddd'))

1 reply

Databaser
Forum|alt.badge.img+25
  • Brainy
  • Answer
  • October 18, 2023

This should work for that:

IF({Publish Date}, DATETIME_FORMAT({Publish Date},'dddd'))