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

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

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

Tags:

Comments

  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭
    Options

    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.