Forum Discussion

JessicaStevens's avatar
JessicaStevens
Qrew Member
5 years ago

Color Coding Issues

I was able to get my color coding formula to work, however it only working on some of the items. Here is my forumla:

If([Green Agent]="yes","#96e2ab")

As I mentioned, some of the "yes" marked agents are appearing green but some are not. I read somewhere that is only shows the first 200 values. Is that why some are not appearing to be color coded? Can I bypass this?

------------------------------
Jessica Stevens
------------------------------
Formulas and functions
reports and charts
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    5 years ago

    There is not a 200 record limit. 


    The value in that yes field must be inconsistently typed. Perhaps there are leading or trailing space it else a capitalization issue. 


    So  either fix the data or else change the formula to

    If(Contains([GreenAgent],"yes"),"#96e2ab")



    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • JessicaStevens's avatar
      JessicaStevens
      Qrew Member
      5 years ago
      Thank you. I got it figured out. I changed it to a checkbox instead and problem solved.

      ------------------------------
      Jessica Stevens
      ------------------------------