Using today if no other date

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?

+19

Try this :slightly_smiling_face:

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

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

Hope this helps!

Sign up