Solved

Use formulas to show a list of supported systems for a given function

Forum|Forum|1 year ago
June 26, 2025
5 replies
123 views

I have what I would call an architecture diagram consisting of organizational, functional, and systems data. I’d like to show a list of systems supporting a given function. This is simple using “CONNECTED” when only systems are connected to functions, but tying organizational entities to functions then adds those to the list. Is there a way to “filter” results to only one object class (systems) and filter out organizational shapes?

Best answer by Leianne C

Hi @toddwerts, thank you for posting in the community! It looks like you are trying to use this CONNECTED formula. To confirm, are the systems and organizations referenced in your comment above ‘shape properties / shape data’?

If so, it should be possible to use the formula =CONNECTED."Property name" to get all shapes' shape data property and specify a property. You can see this section of our formulas documentation for more details.

If that is not the case for you, could you please share an example screenshot (feel free to create a simple version or censor any important information!) of your use-case? This will help us take a closer look on our end!

I hope this helps! Feel free to let me know if you have any questions.

S

Suman Chatterjee

Lucid Legend Level 3

Hi,

Can you attach an example of what you are trying to do ? Are you trying to do conditional formatting using Lucid formulae ?

T

toddwertsAuthor

Hi,

Can you attach an example of what you are trying to do ? Are you trying to do conditional formatting using Lucid formulae ?

No conditional formatting. Let’s say I have a Business Function, and I have organizations related showing ownership, and systems related showing their support / execution of the function. I want to display the list of systems on the Business Function shape but not the organization(s). So when I use “CONNECTED,” I get both systems and organizations returned. I want to filter out organizations.

Leianne CAnswer

Lucid support team

Hi @toddwerts, thank you for posting in the community! It looks like you are trying to use this CONNECTED formula. To confirm, are the systems and organizations referenced in your comment above ‘shape properties / shape data’?

If so, it should be possible to use the formula =CONNECTED."Property name" to get all shapes' shape data property and specify a property. You can see this section of our formulas documentation for more details.

If that is not the case for you, could you please share an example screenshot (feel free to create a simple version or censor any important information!) of your use-case? This will help us take a closer look on our end!

I hope this helps! Feel free to let me know if you have any questions.

T

toddwertsAuthor

Please see screenshot for what I’d like to do.

Leianne C

Lucid support team

Hi @toddwerts, thank you for sharing an example screenshot and apologies for the delayed response! It looks like my colleague is already helping you with this in another post. Please continue referring to that post for more information. Thanks!

For any other users with a similar question, you should be able to achieve this using the following formula. Please see the linked community post for more details:

=COUNTIF(SHAPETYPE(CONNECTED(THIS)), x => x != "Line")

I hope this helps. Feel free to let us know if you have any questions!

Create an account in the community

Log in to the community