Skip to main content

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?

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!