Hi, I’m building a comprehensive board for design and project management teams.
I would appreciate a help from formula experts and automation experts here. Thanks.
These are my columns and the rules
- Due Date Column
Rule. When Due Date of an asset is moved to a different day, move the rest of the due dates that follows it with the exemptions of holidays and weekends
- Status Column ( Rules: When the date is 1 day before Due Date, Change Status to Due Tomorrow).
Rule 2. When the due date comes, change Status column to Due Today
- Priority Column
When Status Date Changes to Due Tomorrow and Due Today, set Priority column to High. Otherwise, Low
I hope some can give me valuable advices. I got a a bit lost. Thanks!