Explore Charting Possibilities

Follow New post
0

Formulas against unconnected objects

Hey folks,

I've been trying to solve what seems to be a simple issue with no success and hoping for your help. I have three objects. In two of the objects I have data imported from an external source ("project" in the screenshot). In the third object (dashed outline box in the screenshot) I would like to calculate the sum of data from the other two. The complication is I would need to do so without drawing a connector between them as in reality I have a few dozen shapes with data that need to be connected to a single object, and this pattern repeats multiple times in my diagram.

My solution at the moment is to group the three objects and have the following (example) formula: =SUM(DESCENDANTS."field_name") at the group level. I then have =PARENT."SUM_FIELDS" in the third shape to achieve the end result I am looking for.

Should be noted that it's not practical to reference specific field or object names as they may not be unique across the page.

This seems really inefficient, is there a better way to achieve this? 

Thanks in advance!

Official comment

Avatar

Hi there Bojan, thanks for reaching out! The solution you described is the best way to approach this specific use case at the moment. I want to apologize for any inconvenience this may cause you! If you would like to see more extensive formula features in Lucidchart, please add your ideas to our feature request form.

For any users who want to learn more about Lucidchart, this article in our Help Center offers in-depth explanations on this topic.

Comment actions Permalink

1 comment

Please sign in to leave a comment.