Help

The Community will be undergoing maintenance on Friday January 10 at 2:00pm - Saturday January 11 at 2:00pm EST, and will be "read-only." For assistance during this time, please visit our Help Center.

Re: Is it possible to have a double condition to update a record? (date)

1396 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Rodrigo_Ayala
4 - Data Explorer
4 - Data Explorer

hello community: I have a question, I have a status field and a date field. I would like to change the status when the day of the date arrives. (if date = today). Is this possible?

1 Reply 1

Hey Rodrigo, yeah that’s possible.

Make a formula field with the following formula:

IF([DATE FIELD] = TODAY(), "Yes", "No")

Then make an automation that triggers based on the formula field’s value. Check out a working version here