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.

Project end date - Metric

Neil Huddart
Neil Huddart ✭✭
edited 12/09/19 in Archived 2017 Posts

Hi 

I am trying to create a metric for a Sight sheet to show countdown in days and another in weeks until a project starts

can anyone help ?

Cheers

Neil

Tags:
· Share on FacebookShare on Twitter

Comments

  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭

    =Date23 - TODAY()

    will show how many days are left before the value in the Date column, row 23.

    If you want to stop at 0 on your countdown (negative is past-due) then 

    =MAX(Date23 - TODAY(),0)

    To get weeks, divide by 7.

    If you want an integer number of weeks, look at using ROUND or INT.

    I hope this helps.

    Craig

     

    · Share on FacebookShare on Twitter
This discussion has been closed.

Categories