Find the earliest outstanding date with parameters

Options

Hi all,


I am trying to create a formula, that finds the earliest date in {Date Received}, if the {Date Processed} is blank.

I have tried this formula, but it comes back as #Invalid Column Value:

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

I then added an IFERROR as below, but that returns no value at all.

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


Can someone help please?


Thanks,


Meg

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!