Weeks to go Formula
Apologies if this exists somewhere - I tried to look but couldn't find exactly what I needed.
Using smartsheet to project manage for an event - I am wanting to have a 'Weeks to Go' Column that counts down how many weeks until the exact event date along each task item.
Thanks!
Comments
-
Hi Roxanne,
One way to do this is to have two columns. One that calculates the days left and one that shows how many weeks that is. You could use TODAY or NETDAYS (see example below).
Date Column / Weeks to go column
=TODAY() - Date10 =A10 / 7
=NETDAYS(Date10; TODAY()) =A10 / 7
Would that work for you?
I hope this helps you!
Best,
Andrée Starå - Workflow Consultant / Get Done
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Hey Andree - I'm still partially new to smartsheet. I input with the date but getting an error message - have I formatted this incorrectly with today's date?
=TODAY(31/01/2018) - Date10 =A10 / 7
=NETDAYS(Date10; TODAY((31/01/2018)) =A10 / 7
-
Hi again Roxanne,
Everything looks fine except that you don't need to put the the date in after TODAY(. It should only be TODAY() and the formula will default to todays date.
Best,
Andrée
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Thanks Andrew - I took out the date and just pasted the formula exactly as you wrote it but I'm getting an error message: #UNPARSEABLE
Do I need to be putting the event date somewhere so it calculates from that?
-
Sorry - meant Andree (autocorrect!!)
-
Hi again Roxanne,
=TODAY() - Date1
=Diff1 / 7=NETDAYS(Date2; TODAY())
=Diff2 / 7Please see attached link/screenshot for a more detailed explanation.
I hope this helps you!
Best,
Andrée
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!