Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here
May 04, 2022 11:08 AM
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?
May 05, 2022 08:51 PM
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