Find the earliest outstanding date with parameters


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?



Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!