Skip to main content
Solved

Color by % of progress

  • February 2, 2021
  • 6 replies
  • 46 views
E

Dear community,

Does someone know how color a field by level of progress? For example, all tasks under 30% of completion in red, tasks between 30-60% in yellow, tasks between 60-90% in blue and tasks between 90%-100% in green?

I’m sure that is something very easy to do, but I’m new with the PRO subscription and I still learning

Thanks all!

Best answer by Kamille_Parks11

Dear @Kamille_Parks , in color by condition I only can choose 2 fields :weary: Dear @kuovonne I tried with your suggestion but it didn’t work :upside_down_face:


What do you mean you can only color by two fields? Record coloring options, as far as I’m aware, support as many fields as there are present in the table. Can you post a screenshot of your coloring settings?

    6 replies

    Kamille_Parks11
    Forum|alt.badge.img+27

    Under the record coloring options, chose “Color by condition”. Set up one color per “tier”. Your first tier would be “Where {Percent field} is greater than or equal to 90%” and set the color to green. Your next tier would be “greater than or equal to 60%”. Etc.

    kuovonne
    Forum|alt.badge.img+29
    • kuovonne
    • Brainy
    • 6009 replies
    • February 2, 2021

    You can also use a formula field with emoji to indicate color

    IF(
  {completion percent} < 0.3,  
  "🔴",
  IF(
    {completion percent} < 0.6,  
    "🟡",
    "🟢"
  )
)

    Sometimes I use a slightly more complex version:

    IF(
  {completion percent}  & "",
  IF(
    {completion percent} < 0.3,  
    "🔴",
    IF(
      {completion percent} < 0.6,  
      "🟡",
      "🟢"
    )
  )  & " " & ROUND({completion percent} * 100, 0) & "%"
)
    E
    • Elena_Lopez
    • Author
    • Participating Frequently
    • 8 replies
    • February 4, 2021

    Under the record coloring options, chose “Color by condition”. Set up one color per “tier”. Your first tier would be “Where {Percent field} is greater than or equal to 90%” and set the color to green. Your next tier would be “greater than or equal to 60%”. Etc.


    Dear @Kamille_Parks , in color by condition I only can choose 2 fields :weary: Dear @kuovonne I tried with your suggestion but it didn’t work :upside_down_face:

    Kamille_Parks11
    Forum|alt.badge.img+27
    • Kamille_Parks11
    • Brainy
    • 2679 replies
    • Answer
    • February 4, 2021

    Dear @Kamille_Parks , in color by condition I only can choose 2 fields :weary: Dear @kuovonne I tried with your suggestion but it didn’t work :upside_down_face:


    What do you mean you can only color by two fields? Record coloring options, as far as I’m aware, support as many fields as there are present in the table. Can you post a screenshot of your coloring settings?

    E
    • Elena_Lopez
    • Author
    • Participating Frequently
    • 8 replies
    • February 4, 2021

    What do you mean you can only color by two fields? Record coloring options, as far as I’m aware, support as many fields as there are present in the table. Can you post a screenshot of your coloring settings?


    I’ve done it. However I thought that I could see the color in the % not close to the principal field…

    NLOIA
    Forum|alt.badge.img+10
    • NLOIA
    • Inspiring
    • 21 replies
    • April 15, 2024

    Hi!

    I did a slight change to match my board:


    IF( {Percent} & "", IF( {Percent} < 0.25, "🔴",
    IF( {    Percent} < 0.5, "🟡", "🟢" ) ) &
    " "     & ROUND({Percent} * 100, 0) & "%" )



    And now I need to make this result be used as the color of the task (register).
    But the field I created with this formula do not appears in the "Color" menu options.
    How can I use it as a coloring option?

    THX!

     


    Terms & ConditionsAccessibility statement