I have a formula field in one of my bases that is designed to show us how much work is left to be done before a project's start date.
So we have the start date and the number of outstanding tasks. The formula field looks at those two fields and lets us know how many tasks per day are due.
What I would like to do is drive an automation flow in the event that formula field spits out a number that is higher than it was before. In other words, if we've been at 2 tasks per day but it jumps to 3 tasks per day, I'd want to know that.
But I don't see any straightforward way to monitor a formula in this manner. Anyone have any creative ideas?