Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Using today if no other date

Topic Labels: Formulas
380 1
Showing results for 
Search instead for 
Did you mean: 

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

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!