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

Sophie Finckh
edited 12/09/19 in Archived 2017 Posts



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



  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭

    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.