Solved
Calculate connections
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.
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.
Your privacy choices
