Add Ons and Integrations

Add Ons and Integrations

Ask questions about Control Center, Dynamic View, DataMesh, Pivot App, Calendar App, or WorkApps. Discuss connecting Smartsheet to your other systems with integrations such as Bridge, Data Shuttle, the Jira connector, and the Salesforce connector.

SCC: Dependencies enabled project plan blueprint that can pull date from profile data for Start of p

Hello All


Wondering if anyone might be able to help me figure out how to pull in a dependency enabled project plan start date into the summary section at the top of the sheet so that it is profile data. I read that you can use formulas. Would I have to create a new total separate meta data sheet and cell link it? I would like to pull the Start Date into profile section for Security - Start Date.


Here is a post about the same issue but I dont think it describes a solution that I can use.

SCC: Help using dependencies in blueprint that can pull date from profile data for Start of project — Smartsheet Community

Answers

  • Community Champion

    Hi @Lori Khoury

    One way to do this within in the same sheet is to add a Sheet Summary field (the popout window on the right) for the start date and then "=" to that field in the Summary Profile Data section you have in grey in the picture.

    You might need to do =([Start Date]16) + ""

    or =DATEONLY([Start Date]16) + ""

    This will get the Date Type value to appear as a Text/Number value where needed.

    I hope that helps.

    Matt

    Matt Johnson

    Sevan Technology

    Smartsheet Aligned Partner

Trending Posts