COLLECT formula year criteria confusion


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!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!