Forum Discussion

Qrew Captain

3 years ago

Help with formula (colors)

Getting this message: [BOARD RATE] var text ButtonColor = Case([CP - DW.2 BOARD RATE LABOR ONLY $]>0, "#e600e6"); var text WordsColor = Case([CP - DW.2 BOARD RATE LABOR ONLY ...

Formulas and functions

MarkShnier__You

Icon for Qrew Legend rank

Qrew Legend

try this. Use IF in that situation as opposed to CASE.

var text ButtonColor = IF([CP - DW.2 BOARD RATE LABOR ONLY $]>0,
"#e600e6");

var text WordsColor = IF([CP - DW.2 BOARD RATE LABOR ONLY $]>0,"BLACK");

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------

Qrew Captain

3 years ago

var text ButtonColor = IF([CP - DW.2 BOARD RATE LABOR ONLY $]>0,"BLUE");
var text WordsColor = IF([CP - DW.2 BOARD RATE LABOR ONLY $]>0, "black");

------------------------------
BuildPro
------------------------------

BuildPro
Qrew Captain
3 years ago
Found this:
If( [CP - DW.2 BOARD RATE LABOR ONLY $] > 1,
"<span style='background-color: #ffb3b3'>" & "$" & ToText(Round ([CP - DW.2 BOARD RATE LABOR ONLY $])),
"$" & ToText (Round(([CP - DW.2 BOARD RATE LABOR ONLY $]))))

this works kind-of
...how do we make the entire field red, leaving the $21 black?

thx

------------------------------
BuildPro
------------------------------
- MarkShnier__You
  Qrew Legend
  3 years ago
  are you looking for a button type appearance?
  
  ------------------------------
  Mark Shnier (YQC)
  mark.shnier@gmail.com
  ------------------------------
  - BuildPro
    Qrew Captain
    3 years ago
    Hi Mark,
    A button would be fine
    I tried to use the button formula we had created, but couldn't figure out how to capture the value from [CP - DW.2 BOARD RATE LABOR ONLY $] field.
    thanks
    
    ------------------------------
    BuildPro
    ------------------------------