Nesting MIN and IF functions

edited 12/09/19 in Formulas and Functions

Hi, guys!

I am trying to create a function which will tell me the next date where a certain condition is met. I have a column called "Due" with due dates for a report and a column called "Received" with a checkbox. I would like to calculate the due date of the next report which has not already been submitted. 

To find the earliest due date I would use =MIN(Due1:Due10) and to count incomplete reports I would use =IF(Received1:Received10 = 0, ...) but I can't find a way to combine them. Is there another way to approach this?

Thanks for any advice!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!