Hey everyone, really hope someone can help me with Formulas because I am not getting it.
Here’s the layout: I have a board I am using for budgets with the following columns:
-Contract -Budget -Spent -Difference -Budget Status
Contract is the overall sum.
Budget is what we can work with.
Difference is obvious.
Budget Status- has four Status’ (Good, Over, Under, Close to Limit)
Is there a formula to make it so, let’s say, if difference goes below $1000, change status to Close to Limit.
If Difference is more than budget, change status to Over?
And so on and so forth.