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?
Is it possible to have a double condition to update a record? (date)
+31Hey 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
Login to the community
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.