Forum Discussion

TonyMiller's avatar
TonyMiller
Qrew Member
3 years ago

Using multiple colors based on checkbox

I'm trying to use a different color based on whether a checkbox is checked.

case([Standards],true,"#5E9DFF",([LOA]),true,"#F54400")
 It gives me an "Expected text but got bool" error.  I don't need both to be true, just if [Standards] is checked then one color or if [LOA] is checked then another color.
Thoughts?

I can get one color to work, but not able to add the other.


------------------------------
Tony Miller
------------------------------

2 Replies

  • try this


    IF(
    [Standards],"#5E9DFF",
    [LOA],"#F54400")



    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------
    • TonyMiller's avatar
      TonyMiller
      Qrew Member
      That worked.  Thank you.

      ------------------------------
      Tony Miller
      ------------------------------