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
-
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
-
Do you have formulas in any of the referenced columns? What column is the above formula in?
-
It is in the insurer column
-
Oh, Well there's the problem. You can't reference the column the formula is in. You have a number of options. The most simple would be to move the formula to a different column. If you are wanting to only reference the child rows of the row the formula is on, you can use the CHILDREN function.
-
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
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.5K Get Help
- 432 Global Discussions
- 152 Industry Talk
- 494 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 76 Community Job Board
- 504 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 307 Events
- 37 Webinars
- 7.3K Forum Archives