Formula Writing Help Needed

I am a formula newbie and need some help. I am hoping this is even possible. Any help is welcome!!

If the Expiration Date field is TODAY then I need to have Executed Agreement On File? field changed to No and the Status field changed to Expired. These values are from picklists.

Can this be done and if so, how do I write it out?

Thanks much!

Hi @Tammy_Gagnon - fields can’t be formulas and picklists/single selects at the same time I’m afraid, so you can’t implement this as you describe with formulas. You could have other status fields (using formulas) that supplement your existing “Executed Agreement” and “Status” fields. Something like:

IF(AND(Date, Date <= TODAY()), 'Expired')

JB

Ok, thanks for the feedback.