Finding the minimum value in non blank cells

Options
2»

Answers

  • Chamudi Withanawasam
    Options

    Also... removed the MATCH as well. It return 05/03/21 which is the start date of the Procurement task :'(


    =MIN(COLLECT({TEst Project Start}, {TEst Project Parent}, 0, {TEst Project % Complete}, NOT(1)))

  • Chamudi Withanawasam
    Chamudi Withanawasam ✭✭✭✭
    edited 03/04/21 Answer ✓
    Options

    Ok finally figured out a way!!!! Eliminated the NOT with the value and seems like it's working


    =INDEX({TEst Project Task Name}, MATCH(MIN(COLLECT({TEst Project Start}, {TEst Project Parent}, 0, {TEst Project % Complete}, 0)), {TEst Project Start}, 0))


    Edit: ok no it doesn't work :3 only works for some sheets only.


    I give up :( :(

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!