Need to Sum Countif of an entire column when the Smartsheet columns change
We had a procedure that worked well summing an entire column using sum countifs. But we noticed when a new column is added to the referenced sheet it causes the function to break. What other function will work in the same way but also not cause it to break like the current function does when a new column is added.
=SUM(COUNTIFS({Green Range 1}, "Red", {Blue Range 2}, "Yellow"), COUNTIFS({Orange Range 1}, "Red", {Black Range 2}, "Yellow"))
Answers
-
It shouldn't break if your cross sheet references are all single columns selected individually. Are you able to provide some screenshots for context?
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!