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?
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
IF({Date}, {Date}, TODAY())
Where {Date} is the name of your Date Field.
Hope this helps!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.