Help with MIN and MAX formula referencing another sheet

Sarah L

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?

Christian Graf

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!