Countifs with Index Match circular reference issue

Options

I'm using Index Match Value to pull data from previous matching task and predecessor info. I'm trying to add a Countifs funtion for conditional formating purposes. It works in the 1st cell until I copy the function across to include the cell I want the count it. I'm assuming because that cell is in the index range but it's not actually the cell I'm counting. Thoughts on how to get around the circular reference error?

S. Fisher

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!