Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Using today if no other date

Topic Labels: Formulas
1040 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!