Formula to populate parent from one column in another?
Hello,
I'm am combining a bunch of sheets in one and then reporting off of that. For reference, the application is resource tracking, so lots of project plans that I'm combining in one so I can report at a "portfolio level".
Is there a formula that will do this? I want the parent text from the Task Name column to populate in the Sub-project column for any child rows so when I copy the row to the PMO sheet we can report on project and sub-project levels.
YES I've looked at Resource Management Classic, doesn't meet our needs, can't get the Resource Management view anywhere but from SS Resource Views (can't put it on a dashboard for example) and we need to share THAT view.
YES we are evaluating Resource Management but for what we are looking to do, it's like pounding a nail with a sledgehammer.
Andrea Zenner
Program Manager | Infrastructure & Operations
Apogee Enterprises
EAP | Mobilizer | Core Product Certified | Superstar
azenner@apog.com
Best Answer
-
Like this?
If so, here's your formula which you can set as a column formula and forget it:
=IF(PARENT([Task Name]@row) = "Workday", "", PARENT([Task Name]@row))
Answers
-
Like this?
If so, here's your formula which you can set as a column formula and forget it:
=IF(PARENT([Task Name]@row) = "Workday", "", PARENT([Task Name]@row))
-
Perfect! Thank you so much @Mike TV !
Andrea Zenner
Program Manager | Infrastructure & Operations
Apogee Enterprises
EAP | Mobilizer | Core Product Certified | Superstar
azenner@apog.com
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives