Find the value just before Max?
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
-
Hi @KT_H
To get the "Date of inventory check," which is "Just before Max," I would use a formula like this.😀
=MAX(COLLECT([Date of inventory check]:[Date of inventory check], [Date of inventory check]:[Date of inventory check], <MAX([Date of inventory check]:[Date of inventory check])))
Answers
-
Hi @KT_H
To get the "Date of inventory check," which is "Just before Max," I would use a formula like this.😀
=MAX(COLLECT([Date of inventory check]:[Date of inventory check], [Date of inventory check]:[Date of inventory check], <MAX([Date of inventory check]:[Date of inventory check])))
-
@jmyzk_cloudsmart_jp thank you! That helped me push through!
-
Happy to help!😁
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 209 Industry Talk
- 441 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 297 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!