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.
Tags:
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
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!