Help

Need help removing Error from a formula

Topic Labels: Formulas
Solved
Jump to Solution
299 1
cancel
Showing results for 
Search instead for 
Did you mean: 
wlauro1
4 - Data Explorer
4 - Data Explorer

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

1 Solution

Accepted Solutions
Databaser
12 - Earth
12 - Earth

This should work for that:

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

See Solution in Thread

1 Reply 1
Databaser
12 - Earth
12 - Earth

This should work for that:

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