Days Until Next Task Due

Danielle Ferrari

Hello,

I have a column of upcoming task due dates, and would like to compute the number of days until the next upcoming task. I have read about =MIN(COLLECT but can't seem to get the formula correct. I know the >TODAY function should be included in the formula somewhere as well.

Thanks!

Bassam Khalil

@Danielle Ferrari

Finish:Finish is the column of the Dates

Are you insert the formula in a Date column type, because if you insert it in text / number column type will not work

Andrée Starå

Hi @Danielle Ferrari

I hope you're well and safe!

Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@workbold.com)

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Danielle Ferrari

@Andrée Starå here is the column I'm trying to extract data from. As you can see, some of the dates have already passed. I would just like to create another sheet that I can show the number of days until the next upcoming task is due - in this case, the nearest due date is 8/20/2021.

Bassam Khalil

Hi @Danielle Ferrari

Hope you are fine, if you need the formula that collect the nearest due date from today you can use the following formula:

 =MIN(COLLECT(Finish:Finish, Finish:Finish, @cell > TODAY()))

the following screenshot shows the result

Danielle Ferrari

@Bassam Khalil Thank you for helping. Could you please explain the part of the formula "@cell"? Which cell would I click for that?

Bassam Khalil

@Danielle Ferrari

@cell is a function in smartsheet used inside another functions to make the criteria check the cells of the columns one by one.

Danielle Ferrari

@Bassam Khalil did you manually type out Finish:Finish?

Danielle Ferrari

@Bassam Khalil this formula is producing the number 0, not showing the cell with the nearest date.

Bassam Khalil

@Danielle Ferrari

Finish:Finish is the column of the Dates

Are you insert the formula in a Date column type, because if you insert it in text / number column type will not work

Danielle Ferrari

@Bassam Khalil that was the issue - it was the incorrect column type. Thank you so much!

Bassam Khalil

@Danielle Ferrari 

You are welcome and i will be happy to help you any time.

and I will be grateful for your "Vote Up" or "Insightful"

Andrée Starå

@Danielle Ferrari

I saw that Bassam answered already!

Let me know if I can help with anything else!

Best,

Andrée