Cell Linking and Circular References

I have created one parent sheet with multiple columns of information that I have copied into more limited child sheets. I've linked in all of the information in the child sheets from the parent sheet, so when the parent sheet is updated, the child sheets update with the related information. I do however want to give users of the different child sheets the ability to update information in their sheet, and be able to see this updated information reflected in the parent sheet via a circular reference.

At present, whenever I try to have the child sheets' cells link both information in from and out to the parent sheet, I receive an error stating that I'm not able to have a circular reference. Is there any way around this?

Thanks!

Kelly

Find more posts tagged with

IT & Operations

Account and User Management

Comments

Travis

Hi Kelly, thanks for the question! When using cell linking, only the source cells are editable - the destination cells are read only. If you want users to have the ability to edit the data, they will need access to the source sheet where they can make their changes to the cells.

David Sinclair

Travis,

I would love to have the ability to have the destination cells be editable. Has anyone else voiced a desire for this? Is it something this is currently on the Smartsheet roadmap to be updated? Thank you!