Can I create a Column Formula which automatically applies text in a Parent Row to the Child Rows?
When rows move into my sheet, I use them as parent rows for my projects. I want to have a column formula which automatically pulls in data from the parent row to its child rows. I've tried putting =PARENT() into a child row but it makes all cells in that column empty when I convert it to a Column Formula.
Any assistance would be hugely appreciated - I'm new to Smartsheet forumlas, I've been using Automation as a workaround but this has limitations.
Help Article Resources
Check out the Formula Handbook template!