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.
Answers
-
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
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.3K Get Help
- 364 Global Discussions
- 199 Industry Talk
- 428 Announcements
- 4.4K Ideas & Feature Requests
- 136 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 444 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives