AutoPopulate Child Rows

Hello -

I have Parent rows with a couple key identifiers I want to use for reporting (Change #, Change Assignee).

For a given "Change", I add child rows for each task under that change. If I want to report on the individual tasks, they need to have some of the same information that is in the parent row.

Is there a way to "autopopulate" certain columns when creating a child row under a parent row?

If I add 3 child rows under the parent row for "Change123", can all of the child rows automatically fill in "Change123" in the Change# column?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!