SCC: Help using dependencies in blueprint that can pull date from profile data for Start of project
Hello Smartsheet experts. I am am having trouble figuring out how to take profile data (a project start date) and push it into a toolkit Project Schedule that has dependencies enabled.
I've looked everywhere and am not sure this can even be accomplished.
We are working to build out a standard PPM solution that has a single blueprint leveraging a Metadata to children asset architecture. The project schedule sheet has predetermined phases with expected durations and dependencies laid out.
The goal is to leverage SCC automations to spin-up the toolkits as they're approved. We want to push a "Created" Date from the Intake sheet (Or leverage one in the toolkit itself) to populate the start date column, first tasks on our Project Schedule Sheet.
A few additional details:
- We are not using a summary section at the top of the Schedule Sheet, we are leveraging a Metadata Sheet and linking data back and forth
- I haven't tried using using the "Add Template specific Profile Data" path in control center and our project schedule doesn't have the right setup (Summary header row, Target Column for "Start Date", etc)
If anyone else has successfully done this, I'd love to hear how we can accomplish this. I'm willing to give the template specific profile data path a shot and put the work in to modify the schedule sheet structure, but before I start that, Wanted to ask.