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
edited 12/09/19 in Archived 2017 Posts


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 ?




  • 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.



This discussion has been closed.