Help

Help writing formula field

Topic Labels: Formulas
1520 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Megan_Rainbow
4 - Data Explorer
4 - Data Explorer

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!

Julian

Megan_Rainbow
4 - Data Explorer
4 - Data Explorer

Thank you very much!!