Help with MIN and MAX formula referencing another sheet

Options

I am trying to pull the MIN date from a column of dates in another sheet and keep getting errors. The sheets are in the same workspace. What am I doing wrong?


Answers

  • Christian Graf
    Christian Graf ✭✭✭✭✭
    Options

    Hello @Sarah L,

    You might try using the MIN formula in conjunction with COLLECT. I believe you have to use something with MIN in order to pull from another sheet.

    You might try something like this:

    =MIN(COLLECT({Closest-to-Close Daily Standups Project PI Range 2}, {Closest-to-Close Daily Standups Project PI Range 2}, <>""))

    Please make sure your Column types are dates for the sheet you are searching, and the sheet you are searching from.

    Hope this helps!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!