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!

Find more posts tagged with

Formulas

Project Management

Update Requests

Comments

rjudenberg

Try using the COLLECT function inside your MIN function

mmiddleton

That worked! Thank you so much!

Sign in to join the conversation!

Quick Links

Trending discussions

Getting error message in approval email
Hey, Is anyone else facing this issue in the approval notifications sent through smartsheet
Add Package Count Based on Customer
I have a sheet with a list of customers in one column, and then the following columns are City, Monday, Tuesday, Wednesday, Thursday, Friday. I need help with a formula that I can put in my sheet summary so that if the customer column says Staples (It can say this in multiple rows) that it will tell me the total package…
Issue with automation process reporting a date in a special column
In the Smartsheet sheet “CRS RO Master” we have programmed an automation called “Track Changes in dates, confirmation and LHG code” [PICTURE 1] This one should report a date of a change in the columns “CRS GO LIVE DATE” and “PMS Go LIVE DATE” in the column “. CRS Check date changed”. [PICTURE 2] The update of the “Go live…