Skip to main content

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?

Hey Rodrigo, yeah that’s possible.


Make a formula field with the following formula:


IF(FDATE FIELD] = TODAY(), "Yes", "No")

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


Reply