Skip to main content

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.

 


Awesome, thanks Lance 👍


Reply