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
Options
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
Comments
-
=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
This discussion has been closed.
