Skip to main content

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.

Hi and welcome @Megan_Rainbow


This should sort it for you:



Hope this helps!


Julian


Thank you very much!!


Reply