Can I use max collect where the criteria has two possible outcomes?
Hi, currently i have a formula that looks collects a maximum date based on 2 criteria. (material type and delivery, usage or cycle count column).
i would like to collect the data if its a usage case or delivery, can i use an "or" in my formula or something?
current formula:
=MAX(COLLECT({Metal Inventory Intake / Form Range 8}, {Metal Inventory Intake / Form Range 3}, ="Bronze'", {Metal Inventory Intake / Form Range 2}, ="USAGE"))
desired fromula:
=MAX(COLLECT({Metal Inventory Intake / Form Range 8}, {Metal Inventory Intake / Form Range 3}, ="Bronze'", {Metal Inventory Intake / Form Range 2}, ="USAGE" or "DELIVERY"))
Answers
-
You would incorporate the OR function like so:
=MAX(COLLECT({Metal Inventory Intake / Form Range 8}, {Metal Inventory Intake / Form Range 3}, ="Bronze'", {Metal Inventory Intake / Form Range 2}, OR(@cell = "USAGE", @cell = "DELIVERY")))
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 396 Global Discussions
- 213 Industry Talk
- 448 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 133 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!