Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Convert Project Sheet with Start/End Dates to Weekly Summary Showing Items Starting/Ending/In Progre
Hi - is there a way to convert a project sheet with items that have Start/End dates listed, into a week by week summary report that shows the status of each of those items in a particular week? In any week, I'd like to see which items are Starting (based on Start Date), Ending (based on End Date), and In Progress (assuming their start/end dates are prior to/post the particular week). I don't want to see just 1 week at a time, but the whole set of weeks based on all the items in my project sheet (so a single item could be listed in the summary report under multiple weeks).