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.5K Get Help
- 468 Global Discussions
- 156 Industry Talk
- 511 Announcements
- 5.5K Ideas & Feature Requests
- 87 Brandfolder
- 156 Just for fun
- 81 Community Job Board
- 520 Show & Tell
- 35 Member Spotlight
- 3 SmartStories
- 307 Events
- 35 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!
Trending in Formulas and Functions
- I saw someone else asked the same question in another thread https://community.smartsheet.com/discussion/108384/including-a-comma-for-currency-within-an-existing-formula but the answer was very confus…
- I created the formula below and it is working for the section that says "Validations - Issue Validations" and "Validations - Regulatory Issue" part and I can't figure out why =IF([Risk Activity]@row =…
- I am struggling to come up with a solution to convert a timestamp string to a date. The format of the timestamp has the month spelled out as in "January 25, 2025 9:15 am." Many thanks, TARA