FORMULA HELP? max/collect/if

I am trying to get information from another sheetA to sheetB

I want to bring the MAX {MVMG} month vs month growth from sheetA to sheetB if the depot column on sheet A {depot} = depot@row sheetB

Lack of sleep ... I have tried all sorts of formulas any suggestions welcome and much appreciated 🙏

Please bear in mind new rows are added to sheetB every week

Thanks 😊



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!