MIN COLLECT WITH 2 CRITERIA, ONE IS A BLANK CELL

Options

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

  • Courtney S.
    Courtney S. ✭✭✭✭✭
    edited 06/07/24
    Options

    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
    Options

    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
    SteyJ ✭✭✭✭✭✭
    Options

    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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!