Countifs with Index Match circular reference issue
Sfisher
✭✭✭
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
-
Hi @Sfisher -- can you maybe screenshot this? It's a little difficult to image what you're saying.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!