Help

Using today if no other date

Topic Labels: Formulas
664 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Jace_Proctor
4 - Data Explorer
4 - Data Explorer

I’d like a formula field to return =today() if another field is blank, but if the other field is already populated, to use that date instead.

Any help crafting this?

1 Reply 1
AlliAlosa
10 - Mercury
10 - Mercury

Hi there @Jace_Proctor!

Try this :slightly_smiling_face:

IF({Date}, {Date}, TODAY())

Where {Date} is the name of your Date Field.

Hope this helps!