Hi,
Is it possible for the progress bar to represent the amount of progress based on RYG balls. EG/ if red = 0%, yellow = 50% and green = 100% the progress bar would be an average of how many of each colour there were?
Thank you
You would have to create a formula that counts the number of each type of ball, gives them a value of 0, 50 and 100 and then averages and rounds that value to the closest 0, 50, or 100%. You might try starting with an if statement that does the calculation and rounds the % based on whether its over 25% or Under, if the total is over 75% or under and outputs the code necessary to display the bar... empty, half, or full.
