Rich text duration field
Hello, I am attempting to create a rich text field that will change the color of the field if the field is a negative or positive number. The field I am attempting to do this on is called [YTD Cha...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendTry this
If([YTD Change-Incoming to Answer] > Days(0) , "<div style=\"background-color:red;\"> Urgent</div>", [YTD Change-Incoming to Answer] )
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
If([YTD Change-Incoming to Answer] > Days(0) , "<div style=\"background-color:red;\"> Urgent</div>", [YTD Change-Incoming to Answer] )
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- Hi Mark!!!
It's giving me the error "expecting text but found duration" on the last [YTD Change-Incoming to Answer] in the formula.
------------------------------
Courtneah Thomas
------------------------------- MarkShnier__YouTry this
If([YTD Change-Incoming to Answer] > Days(0) , "<div style=\"background-color:red;\"> Urgent</div>", ToText([YTD Change-Incoming to Answer] ))
im not really sure which unit of measure it will show, but see what that does.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- Once again, Mark to the rescue!
------------------------------
Courtneah Thomas
------------------------------
