Copy PARENT cell data to CHILD CELL without deleting DATAMESH field links.

Geoff Baker
Geoff Baker ✭✭✭✭✭✭
edited 03/08/22 in Formulas and Functions

Ok, I have a challenge with formulas and data being overwritten.

I am trying to create a FILTER for my procurement teams to use. I ONLY want to show items where the PROCUREMENT COUNTRY is "CHINA". When I create that filter the CHILD rows do not show because the PROCUREMENT COUNTRY is "BLANK".

So I need to copy the PARENT cell data in this case "CHINA" to the CHILD CELL.

The challenge I have is that I use DATA MESH to fill the PARENT cell data.

When I create the formula "=PARENT()" in the CHILD row it deletes the DATA MESH cell link.



Any assistance for a workaround would be greatly appreciated.

I am on the ADVANCED platform so have tools available.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!