Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Formula for progress bar based on RYG balls
Comments
-
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.
This discussion has been closed.