Help with a formula
I am trying to get THe project column to auto populate with the "children" from the source sheet when the "sign Type" is selected.
Best Answer
-
It sounds like you are trying to auto-generate a task list that is specific to each type of sign when a new project is identified.
What do you think about using an automation instead of a formula?
You would create an automation on your Source sheet that would copy the rows (parent and children) over to the target sheet when triggered by selecting "Create Project" on the parent row of the source sheet. You can then rename the project and track as usual on the target sheet.
Source:
Target:
Jessica Selano | Selano Consulting
jessica@selanoconsulting.com
Answers
-
It sounds like you are trying to auto-generate a task list that is specific to each type of sign when a new project is identified.
What do you think about using an automation instead of a formula?
You would create an automation on your Source sheet that would copy the rows (parent and children) over to the target sheet when triggered by selecting "Create Project" on the parent row of the source sheet. You can then rename the project and track as usual on the target sheet.
Source:
Target:
Jessica Selano | Selano Consulting
jessica@selanoconsulting.com
-
Thank you Jessic!!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 489 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!