Aggregation sheet

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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!