I am trying to run automations that automatically change the priority status according to how many days before a due date. But my automations are not working, does any one have a reason for this/ a better way to do this?
Hi Hannah,
The problem is “and only” repeated 3 times. Your priority is either medium, critical or high, it can’t be Medium and Critical and High… Create 1 automation for each priority.
Want to take your formulas to the next level? Try the Advanced Formula Booster, the app that reinvents formulas in monday.
- Create formulas without using the Formula column (and avoid its limitations)
- Build formulas involving data from the previous item, the next item, the sub-items, the parent item, even items in the same group or the same board.
- In one formula, update multiple columns from multiple items.
Check our blog for real use cases.