You are reading a single comment by @Chalfie and its replies. Click here to read the full conversation.
  • 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.

About

Avatar for Chalfie @Chalfie started