Smartsheet Basics

Smartsheet Basics

Ask questions about the core Smartsheet application: Sheets, Forms, Reports, Dashboards, and more.

Please help with Parent-Child Circular references

I am trying to create a sheet in which the latest data from the child rows is presented in the Parent row so the most current info is always displayed in a collapsed row view. I have several columns I need to "pull into the parent row. I successfully got everything to work as desired. As soon as I tried to copy the hierarchy with the same Parent-child formulas- I got hit with the Circular Reference error as well as a Blocked error. Everything worked perfectly until I tried to copy it over for the next set. Is there anyway around this. The formulas are all based on the specific Parent child relationship for each group and should not be impacted by a completely different group. Here is an example of one of the formulas:

=IF(COUNT(CHILDREN(Patient@row)) > 0, INDEX(COLLECT(Insurer:Insurer, [Date From Hidden]:[Date From Hidden], MAX(COLLECT([Date From Hidden]:[Date From Hidden], [Valid Date]:[Valid Date], 1))), 1), "")

Best Answer

  • Answer ✓

    Thank you. I used a helper column but still had a problem with data from other Parent/child relationships pulling into the parent row. To combat that issue, I created another helper column that gave a unique identifier to all the different sets of child rows. This allowed me to build the formula to only pull the data from the child rows nestled under the specific parent/child grouping I was looking to pull. Thank you for your help

Answers

Trending in Smartsheet Basics