Formula: If Status Changes to Something After Date
I'd like help in creating a formula that depends on another cell changing to a specific status, not if it is that status already.
E.g. to have a checkbox get checked if the status balls of a neighboring cell turn red (after a certain time and date- the time and date of which I input the formula), but not if they were red already.
Help Article Resources
Check out the Formula Handbook template!