Add Ons and Integrations
Add Ons and Integrations
Ask questions about Control Center, Dynamic View, DataMesh, Pivot App, Calendar App, or WorkApps. Discuss connecting Smartsheet to your other systems with integrations such as Bridge, Data Shuttle, the Jira connector, and the Salesforce connector.
Formula for calculating remaining weeks
I have planned start and planned finish dates for projects. I want to calculate/share the weeks or days remaining on a project, and if this is a negative number, meaning we have gone past the planned finish, show this. Suggestions?
Thank you,
Becky
Answers
-
Hello @brhea110891
Hope you are well. We use this formula for Working Days until Go-Live
=NETDAYS([TODAY Helper]23, [Planned Start Date]23)
Planned Start is the beginning of the project
TODAY Helper is a helper column that I use to automate the updating of the TODAY().
NETDAYS returns the number of days between two days.
Hope this helps!
Peggy
-
Thank you, Peggy,
That is very helpful and gets me halfway to where I'd like to go.
I also learned that I can use NETWORKDAYS
Now, what I would like to do is translate the number of NETDAYS days into number of weeks.
Thank you.
Becky
