MAX COLLECT Formula assistance

System

System Employee

08/08/24 in Formulas and Functions

This discussion was created from comments split from: MAX COLLECT Formula.

0 ·

Answers

Jen K. ✭✭✭

08/08/24

Hello,
I'm looking for the same solution, but having trouble following the formula. Can someone provide this formula using more general column names?

0 · Share on Facebook Share on Twitter
heyjay ✭✭✭✭✭

08/08/24
Can you share what your table looks like?
=MAX(COLLECT( {Range_To_Compute}, {RangeCriteria}, [Criteria]1)
...
0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

Check Box for Current Milestone
I am looking for help in writing a formula (or using automations) so that the most recent milestone where the status is "INV PKT SENT & PSR XL UPDT" will have the checkbox. As you can see, I can write a formula to check the box but then when the next milestone reaches that same status I now have multiple checkboxes in the…
managing a dropdown field from a single source used by multiple sheets
we are tracking courses taken by folks throughout our org. each student (apx. 58) has their own sheet (student record), tracking the courses they have taken and the date completed. this is how the owner of the process currently wants this managed. the course catalog is relatively static and we would like it maintained in a…
Can't get the "Ongoing" piece to work
I'm trying to make a formula, a typical status formula which I do often. But it was asked to include an "Ongoing" status when the % Complete column is at 99%, regardless of other conditions. The problem I'm running into is that no matter how I input it, the "In Progress" piece always overrides it, and I can't quite get the…