Forumula to pull oldest date in a column

Heather Druckenmiller

I am trying to pull the oldest date into into a dashboard.  I have my metrics sheet and keep getting the #invalid Column value error.  I am using the MIN forumula and referencing the column on my sheet.                               =MIN({Depot Repair Collection Log Range 1})

Any clues or anyone have a sample formula I should be using.  I made sure the column on my sheet was set as a date column

Jeff Reisman

What happens when you edit your reference?

If you don't see something like this pop up when you click into your formula field, then the reference is missing.

If the reference is there, Edit reference and make sure it goes to the correct column on the correct sheet.

Jeff Reisman

So you can add another criterion range and criteria set after the first set:

=MIN(COLLECT({Depot Repair Collection Log Range 1}, {Request Tracker Range 2 - Status}, @cell <> "Complete", {Request Tracker Range 2 - Status}, @cell <> "Returned")) + ""

Jeff Reisman

What happens when you edit your reference?

If you don't see something like this pop up when you click into your formula field, then the reference is missing.

If the reference is there, Edit reference and make sure it goes to the correct column on the correct sheet.

Heather Druckenmiller

Thank You

Jeff Reisman

Was that the issue? A broken or missing reference?

Heather Druckenmiller

Yes and a few extra characters, all is good. Thanks for your response and help

Jeff Reisman

You're welcome. If you could mark my first answer as Accepted, that would be great.

Heather Druckenmiller

I am now using this formula to give me the oldest date in a column but I now need to add to removed not only anything with a complete status(which is already in the formula) but also to remove anything with at "Returned" status. Everything I try returns an error....any recommendations?

=MIN(COLLECT({Depot Repair Collection Log Range 1}, {Request Tracker Range 2 - Status}, @cell <> "Complete")) + ""

Jeff Reisman

So you can add another criterion range and criteria set after the first set:

=MIN(COLLECT({Depot Repair Collection Log Range 1}, {Request Tracker Range 2 - Status}, @cell <> "Complete", {Request Tracker Range 2 - Status}, @cell <> "Returned")) + ""

Andrée Starå

@Heather Druckenmiller

Hi Heather,

Try something like this.

=MIN(COLLECT({Depot Repair Collection Log Range 1}, {Request Tracker Range 2 - Status}, OR(@cell <> "Complete",@cell <> "Returned")) + ""

Did that work?

I hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!