Automatic Countdown

fh

I am working on a restaurant buildout project list, and want to have a column for "Weeks till Opening Day" and another for "Days till Opening Day". Is there a way to have that automatically countdown to a targeted date?

J. Craig Williams

=[Opening Day] - TODAY()

or look at NETWORKDAY / NETWORKDAYS if you want to only show working days.

Note that Smartsheet does not refresh sheets if no one is looking at them or the sheet is not refreshed in some other manner.

Craig

Mike Wilday

To set the week formula, try this solution. You'll have to adjust for your column names. 

https://community.smartsheet.com/discussion/weeksdays-remaining-formula

I have not tested it but thought it might point you in the right direction. 

Taylor F

Hello,

For the weeks count, you can use the WEEKNUMBER function. 

=WEEKNUMBER([Opening Date]1) - WEEKNUMBER(TODAY())

Let me know if you have any questions.

Taylor

 

Mike Wilday

@Taylor -- nice solution! That should work great.

I also recommend modifying both of these statements with this statement at the beginning to avoid getting negative numbers (unless you want them). =IF(Today()>[Opening Date 1], 0, FORMULAS for calculation)