Is there a way to automatically calculate how many lines are connected to a box in the flow chart?
And if so, can you calculate in & out?
I’m trying to work out how many times an item in used.
Answer
Calculate connections
+1Best answer by Lance
Yes! You can use conditional formatting to accomplish this. In this example image, I have green badges showing the number of lines going out from a shape and red badges for lines going in. I set up a rule that shows a badge if the number of connected shapes is greater than 0, used a custom text badge, and set the custom text to be =COUNT(UPSTREAM) for the red badge and =COUNT(DOWNSTREAM) for the green badge. You can also do =COUNT(CONNECTED) for the total.
+11- Lucid Legend Level 6
- Answer
Yes! You can use conditional formatting to accomplish this. In this example image, I have green badges showing the number of lines going out from a shape and red badges for lines going in. I set up a rule that shows a badge if the number of connected shapes is greater than 0, used a custom text badge, and set the custom text to be =COUNT(UPSTREAM) for the red badge and =COUNT(DOWNSTREAM) for the green badge. You can also do =COUNT(CONNECTED) for the total.
Create an account in the community
A Lucid account is required to interact with the Community, and your participation is subject to the Supplemental Lucid Community Terms. You may not participate in the Community if you are under age 18. You will be redirected to the Lucid app to log in.
Log in to the community
A Lucid account is required to interact with the Community, and your participation is subject to the Supplemental Lucid Community Terms. You may not participate in the Community if you are under age 18. You will be redirected to the Lucid app to log in.
Log in with Lucid
or
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
