Weeks to go Formula

01/28/18 Edited 12/09/19

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

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    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 PARTNER & CONSULTANT / EXPERT

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

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • 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

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    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 PARTNER & CONSULTANT / EXPERT

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

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • 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!!)

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Hi again Roxanne,

    =TODAY() - Date1

    =Diff1 / 7

    =NETDAYS(Date2; TODAY()) 

    =Diff2 / 7

    Please see attached link/screenshot for a more detailed explanation.

    https://cl.ly/pD1Y

    I hope this helps you!

    Best,

    Andrée

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

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

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

Sign In or Register to comment.