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
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 462 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 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!