IF(CHILDREN()) ? - Child inherits parent traits for entire column
I could've sworn I'd seen this but now I can't find it: We have a sheet for incoming project requests. Our general population can request multiple new mkt materials (printed direct mail, email, outlook MSG, etc.) for a campaign in a single 'ticket.' Then our PMO hotseat creates a new child row for each of those unique items and assigns them out. We'd like common parent traits (owner/requester, a master project number, requested on date) to be inherited for all kids. We're manually dropping in "=PARENT()" but would like it do this automatically. Possible? I'm entirely too dumb to figure it out.
Help Article Resources
Check out the Formula Handbook template!