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.7K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 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!