Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Automatic Countdown
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?
Comments
-
=[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
-
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.
-
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
-
@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)
