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), "")

Find more posts tagged with

Accepted answers

Todd O

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

All comments

Paul Newcome

Do you have formulas in any of the referenced columns? What column is the above formula in?

Todd O

It is in the insurer column

Paul Newcome

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.

Todd O

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.