Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Help writing formula field

Topic Labels: Formulas
613 2
Showing results for 
Search instead for 
Did you mean: 

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 2

Hi and welcome @Megan_Rainbow

This should sort it for you:

Screenshot 2019-05-10 at 21.42.43.png

Hope this helps!


Thank you very much!!