Collect Function with Multiple Criteria
I have the following collect function that works fine when I only have one criterion (the answer is 6) but, when I add the additional criterion to evaluate the Date I get an answer of 1 instead of the 6 I was expecting. Any help would be appreciated.
Answers
-
This seems to be because the size of the Date Range (1 column) is different then the size of the range being collected (3 columns).
You may need to count each column separately (A separate COLLECT for Column4 another for Column5 and another for Column6).
-
Thank you Leibel, that works. Would you know how much would be the impact to performance if I were to have three Collect functions vs one? My sheet is already slow and don't want to affect performance more.
-
No idea...
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!