Aggregation sheet

Becky Clayton

I manage a workflow spreadsheet that has a dashboard attached to it, the dashboard looks to find total revenue along with total outstanding number of pieces of work, and the oldest date of the outstanding work.

For some reason the oldest outstanding reference formula I'm using on the aggregation sheet isn't working as intended.

I'd like it to reference the date received, date processed columns, and then pull through the oldest date received where there's no date processed date. This is the formula I'm currently using -

=(MIN(COLLECT({Date Received}, {Date Processed}, "")))

Is anyone able to advise of the formula I'd need to use, please? Thanks in advance

Becky Clayton

Answered

Genevieve P.

Hey @Becky Clayton

I'm glad to hear you found an answer! Can you post your new formula here in case it helps someone else with the same question?

Thanks,

Genevieve