Formula to find the the highest sum of a consecutive list of data

edited 01/09/24 in Formulas and Functions

I need help trying to figure out a formula that will find the max consumption qty of a particular item on a given day. The tricky part is that there are multiple instances per day of consumption for each item.

It would need to to understand that each day is also a unique identifier and sum accordingly per item.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!