Can the Yearday function be used to identify all day numbers for a range of numbers?
Hello,
My primary challenge is that I'm trying to use legacy Smartsheet functionality in place of Smartsheets Resource Management functionality.
So, I have a project plan created in Smartsheet and I am trying to evenly distribute the Hours per task across the Duration (start and finish dates), because I want to create a graph that will help to show me if any of the project resources are overallocated (i.e. if they are assigned tasks that sum up to more than 8 hours /day)
I know the hours per day that each task will take, but I do not know how to assign those hours to each day in the range of the start to finish dates.
The DAY(s) column is where I have the YEARDAY formual right now, =YEARDAY(Finish@row) right now it is only telling me what day the task ends on. Is is possible for the column to be populated with the number of every day in the range?
I was thinking then I can use a pivot table to sum up how many hours are assigned to team member for each day of the year and a graph would give me a nice visual of how many hours are assigned to each individual by day.
TIA,
Sarah
Answers
-
You should be able to just leverage your two existing date columns. If you create a second sheet that has every date of the year going down a single column, you can write your formulas to grab the hours per day for each row in the project plan that has a start and end date that overlaps the date on each row.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 396 Global Discussions
- 213 Industry Talk
- 448 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 133 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!