Discussions

Expand all | Collapse all

Color Coding Issues

  • 1.  Color Coding Issues

    Posted 17 days ago
    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
    ------------------------------


  • 2.  RE: Color Coding Issues

    Posted 17 days 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
    ------------------------------



  • 3.  RE: Color Coding Issues

    Posted 17 days ago
    Thank you. I got it figured out. I changed it to a checkbox instead and problem solved.

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