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.

Same Sprint, Multiple Sheets

Scott Gray
edited 12/09/19 in Archived 2017 Posts

Hi Folks,


I work in a development/consulting team where we have resources working with multiple PMs and across multiple projects. Because of this we do our scheduling/resourcing together and operate on the same sprint schedule. So Sprint 1 for project A might be Sprint 3 for project B, but they have the same start and end dates.  So we traditionally our Sprints are done as "March 6th to March 10th". 


Is there a way to setup a 'master' sprint list that all sheets can use or will this drop down need to be repopulated for every project/sheet that we run? This could be fairly time intensive for us given that we may have ~40 projects in flight at the same time with new ones starting every week. If each PM needs to carve out 20 mins per project to rebuild that list... :(


Any help/suggestions, would be very welcome,



  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭

    Are you only looking to update the dropdown lists?



  • Scott Gray
    edited 03/13/17

    Yessir. We're hoping to align the drop downs across all sheets to match our current method (used in Trello) giving date ranges to our sprints so we can keep them aligned. Using the standard sprint 1, sprint 2, sprint 3, is confusing for our team b/c we can either setup that the 9th week of 2017 is sprint 9 but based on our template project plans sprint 9 is an actual milestone so cards for project A being in Sprint 9 and cards for project B being in Sprint 9 could potentially mean different things.


    Anywhoo... yeah. Long answer to wanting to update the dropdowns in a central location so all sheets reference that same updated dropdown.

  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭



    Richard at Smarter Business Processes has solution using Azuqua.

    You can contact him at richa[email protected] for a free 1 hour consultation.


    Richard is a colleague of mine.




This discussion has been closed.