Trying to figure out how to leverage a name to autofill assigned to in children tasks.
I have a sheet where people are picking up open assignments. This is being linked to the master sheet with the Parent and children tasks. I am trying to figure out how the "pick up assignment" can auto fill in the "assigned To" child tasks once the Pick up assignment has been filled out?
See attachment for more detail?
Answers
-
Unless I'm missing something, you can just do =[Pick Up Assignment]@row in the Assigned To column and make that a column formula.
If you want Sally Sue as the default assignment then it's =if([Pick Up Assignment]@row<>"", [Pick Up Assignment]@row, "sally.sue@yourcompany.com"
Note that in the formula above, you have to return the full email "sally.sue@yourcompany.com", not a name like "Sally Sue", for Smartsheet to recognize the contact.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!