MIN COLLECT WITH 2 CRITERIA, ONE IS A BLANK CELL

Brandon Morales

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?

Courtney S.

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?

Brandon Morales

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)…

SteyJ

https://community.smartsheet.com/discussion/comment/440028#Comment_440028

Hi Brandon, you could do this

=MIN(COLLECT([LATEST ETA]:[LATEST ETA], THICKNESS:THICKNESS, CONTAINS("4/4", @cell), [DATE RECEIVED]:[DATE RECEIVED], ""))