Nesting MIN and IF 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!
Comments
-
Try using the COLLECT function inside your MIN function
-
That worked! Thank you so much!
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!