I would do a if <today formula to help me get there but there are 3 entities submitting bits by a due date, if overdue the due date is red, if received from all the due date is grey so i need to count the days when it is red if that makes sense? May be worth having a look at coming in from the other side tbf
Sometimes, before I get my nested IFS right I like to write helper columns for each part of the statement so that if the condition I want = 1. Then I work out what the combinations are that I want. Then I write a nested if. If I'm having one of those days where I can't hink it through.
I would do a if <today formula to help me get there but there are 3 entities submitting bits by a due date, if overdue the due date is red, if received from all the due date is grey so i need to count the days when it is red if that makes sense? May be worth having a look at coming in from the other side tbf