MIN COLLECT WITH 2 CRITERIA, ONE IS A BLANK CELL
Hey, im looking to create a formula that collects a minimum date from a column with a specific criteria from the thickness column and where date received is blank- any ideas?
Answers
-
Hi Brandon,
- When you say "a minimum date from a column" - does that mean you want the smallest date in a range of columns? Which columns would you want it to look in, to return the smallest date among them?
- When you say "a specific criteria from the thickness column" - what kind of criteria? Do you just need the thickness column to be answered / not blank, or do you want the formula to only work when the thickness column has certain specific answers?
-
Hi, I'm looking for the smallest date in the latest eta column that matches a specific thickness in the thickness column and has not been received.
For example, I would like the smallest date in the latest eta that has 4/4 MAH as a thickness and also has not been received (date received column is blank)…
-
Hi Brandon, you could do this
=MIN(COLLECT([LATEST ETA]:[LATEST ETA], THICKNESS:THICKNESS, CONTAINS("4/4", @cell), [DATE RECEIVED]:[DATE RECEIVED], ""))
Sincerely,
Jacob Stey
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.3K Get Help
- 364 Global Discussions
- 199 Industry Talk
- 428 Announcements
- 4.4K Ideas & Feature Requests
- 136 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 445 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!