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?
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!
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.
With in Dynamic View's details panel is there a way you can start to type some of the drop down information to pull up that option instead of scrolling for the right one? See below 'Market' can't type. Am I doing something wrong or is this by design? If by design I vote for an update.
Hello, I am looking to leverage the Conditional Junction: Junction Match module to set a variable to ultimately decide which path to take. Taking a step back, I have 4 of the same 'When Column is Changed' triggers, which are attached to different smartsheets. Based on which smartsheet the trigger is associated with, I am…
Hello. I am a newer user of Smartsheet and am trying to identify an easy way for multiple contributors around our org to update data in a source sheet. Here is an outline of our scenario: We collect high level data of projects from around the Org in a "Combined Project List" sheet We would like to minimize access to this…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.