Find the value just before Max?

KT_H ✭✭✭

I am trying to use Smartsheet to keep inventory of products I use incrementally but I am running into a formula issue that I am unable to solve. I have been using MAX(COLLECT()) to pull the most recent inventory check for an item, but I want to be able to pull the previous check as well so that I can compare how much product was used between checks.

Does anyone have a recommendation for the best way to pull both checks?

Unique values I can currently reference:

  • Date of inventory check
  • Inventory check number
  • Part number

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!