Can you copy parent row info to child rows within the same column?

I am trying to figure out a formula to autofill a few columns in a child row with information from the parent but can't figure out how to do it without creating new columns. Is it possible to do this within the same column?

The sheet is mostly used in card view so when team members add a subtask they will fill in the task column but not always go back to populate columns that designate the team and timecode to use for the task.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!