Hello! I am hopeful that I can find the solution to this issue. This is a bit of a long one, so get comfortable!


I am using SS to organize the workflow of active jobs at our precision manufacturing facility. Each job requires almost 100 independent job steps from start to finish. Each individual



   I have a task list with a flag column and collaborators in 5 columns, so a collaborator could be the primary responsible or up to a 5th level involved in a task. I haven't been able to use Countifs function in a formula which will retrieve from the list how many tasks a given worker is