Populating a daily Schedule when there is a range for a task
Hey all - I'm hoping someone can jump in and help us with a formula that will look at all the dates in the range and help us pull the information into another sheet when any of the dates in the range are the lookup.
This is our master scheduling sheet which shows a box scheduled for pouring Mar8-Mar17...so 8 production days.
In another sheet, we want to populate the daily schedule for the week of March 8-12 and we need the box to show up in each day.
Using this formula, we can populate the Mar 8th date as it's the first pour date.
=IFERROR(INDEX(COLLECT({Structure ID}, {Cell}, Workstation@row, {Production Start Sched}, $Monday$1), 1), "N/A")
But based on looking at the cell in the master schedule (13 1 3 (1219 box)) and the date we also need to populate the remainder of the week with the same information. Instead of the {Production Start Sched} reference - what would we use to look at the entre start-finish date range?
Thanks!
Amanda
@Kris Rea FYI
Answers
-
Instead of doing the daily schedule as a sheet, could you do it as a report and show the tasks populating in a calendar view? That way they would stretch across all dates in the range?
Would that be easier?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 457 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!