Formulas and Functions
Formulas and Functions
Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.
COLLECT formula year criteria confusion
Arush Godha
✭✭
Hi, I am trying to find the maximum value of values in Column A based on the year it is occurring as per dates listed in Column B. For e.g., finding the minimum value for all 2015 values in Column A.
This is the formula I came up with but it is not working:
=MAX(COLLECT([Column A]:[Column A], [Column B]:[Column ], YEAR(@cell) = 2015))
Please help!
Tags:
Answers
-
Can you be more specific in regards to "it is not working"? Are you getting an unexpected number, or are you getting an error message?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.9K Get Help
- 474 Global Discussions
- 207 Use Cases
- 517 Announcements
- 5.5K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 83 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 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!