autopopulate cells in indented row

Eelin

Hello,

We track projects in indented rows from parent columns. I was wondering if there is the capability to automatically fill in certain columns in the indented rows from the parents. I know that you can add the information in manually using =parent(), but I was wondering if there was a way so taht every time I create an indented row, certain columns are auomatically populated with that.

I hope this is clear. Thank you.

Bassam Khalil

Hi @Eelin 

Hope you are fine, Please add a copy of your sheet or a screenshot (after removing or replacing any sensitive information). This will make it easier for me to provide the appropriate answer to your question.

Andrée Starå

Hi @Eelin

I hope you're well and safe!

It depends. We could maybe use the Column-formula feature to automate it.

Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, [email protected])

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Eelin

Hi everyone,

I've attached a screenshot of my smartsheet.

I would like the information in the parent row (clone, Lot No., Clonality, etc.) to populate automatically into all the child rows.

Thank you!