Hey guys, I would like to set a status based on a date column. For example; “set the status to “Week One”, when date is current week”. Is this possible or would a formula column be better suited to create the automation off of?
This should work for you! A series of these may work for rolling cases.