Skip to main content

If Blank... Formula

  • February 22, 2021
  • 3 replies
  • 33 views
T

I have this formula. If there is no date, the formula errors out. I need it to be the exact same formula but if the date field is blank, it still fills in all the other columns.

Here’s the formula: DATETIME_FORMAT({Date}, ‘YYYY-MM-DD’)&" “&Type&” || "&{Fellow}&{External Guest}

How would I change it to include blank-dates?

3 replies

ScottWorld
Forum|alt.badge.img+35
  • ScottWorld
  • Genius
  • February 23, 2021

This formula should work:

IF({Date}, DATETIME_FORMAT({Date}, ‘YYYY-MM-DD’) & " “)
& Type & ” || " & {Fellow} & {External Guest}

Justin_Barrett
Forum|alt.badge.img+21

Here’s the same formula with the styled quotes fixed:

IF({Date}, DATETIME_FORMAT({Date}, 'YYYY-MM-DD') & " ")
& Type & " || " & {Fellow} & {External Guest}
ScottWorld
ScottWorld
Forum|alt.badge.img+35
  • ScottWorld
  • Genius
  • February 23, 2021

Here’s the same formula with the styled quotes fixed:

IF({Date}, DATETIME_FORMAT({Date}, 'YYYY-MM-DD') & " ")
& Type & " || " & {Fellow} & {External Guest}

Oops! Great catch, @Justin_Barrett! :grinning_face_with_big_eyes:

Terms & ConditionsAccessibility statement