Skip to main content

Help writing formula field

  • May 10, 2019
  • 2 replies
  • 31 views

Hi! I’m trying to write a formula field that will read as “true” when the “end date” is either BEFORE today or ISBLANK. In other words, the label “true” should correspond to records where the end date has not yet passed or is not known.

Can someone help me with the formula for this? I’ve tried my hand at various IF statements, but can’t quite get it to work properly.

2 replies

Forum|alt.badge.img+4

Hi and welcome @Megan_Rainbow

This should sort it for you:

Hope this helps!

Julian


  • Author
  • New Participant
  • May 13, 2019

Thank you very much!!