MIN(COLLECT - Help
Mike B
✭✭✭✭✭
=MIN(COLLECT({LOABal}, [Fund Type]@row, [Fiscal Year]@row, Vendor@row, [LOA#]@row))
Error: #INCORRECT AURGUMENT SET
I am try to get the MIN in a set of values in a sheet. Am I leaving something out in the formula?
Answers
-
@Mike B I think your Collect formula is off - it should be formatted like this:
COLLECT(range, criterion_range1, criterion1, [criterion_range2, criterion2, ...])
It looks like you put the range and then put three consecutive criteria without defining the criteria range. Does that make sense? You'd have the range of values that you want to pull from, then the first range of values to compare against, then the criterion for that first criterion range, and so on.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 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!