Elapsed Days Counter - How?
Hi everyone,
I'm needing to report on elapsed days for a few tasks. Anyone know how to do this?
Note - this is different from the 'duration' function that already exists in the Gannt view. That is where I have a start and end date. In this example, I have a start date, but no end date quite yet.
Any help is greatly appreciated!
Thanks
Comments
-
Heres an example of how to see "how many days has it been since the start of this task"... if the start date is in row 3:
=SUM(TODAY() - [Start Date]3)
-
If you only want to count working days, you can also use the NETWORKDAYS function, taking the difference between your start date and a TODAY reference. This function can also reference specific holidays so that they aren't counted.
-
Something like this?
=NETWORKDAY(Start1, IF(ISBLANK(Finish1), TODAY(), Finish1))
This will count the workdays between start and finish and use today's date if the task has not completed.
-
Hello StacyDe,
Thank you for your comment. I am trying to do the same thing, and I keep coming up with at error (#DATE EXPECTED) when I use your formula. Any clue as to what I'm doing wrong?
Thanks,
John
-
Thank you, I found this formula to be extremely helpful as another way to track at risk tasks and trigger a prioritization review by the appropriate personnel.
-
I know this is old post - but to answer your question - you can do this following formula (they added new formula ot make it easier).
Reason why you got the error - #Date expected because you set the column to date. You need to change it to text/number. They expect the result to be date but the result came out as a number which conflict with the column's type.
What I did was
=SUM([End Date]@row - [Start Date]@row)
It gives me the number of days lapsed - Start date is on May 11, 23 and the end date is May 14, 23, it will give me 3.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.7K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 456 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!