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 Change-Incoming to Answer]. That field is a duration field that displays the number of seconds between last years incoming to answer and this years incoming to answer. If the number is a positive number, I want the field background to be red, as it is a negative change. This is the formula I have but it won't let me use < or > since the field is a duration field. Any ideas?
If([YTD Change-Incoming to Answer] > "0" , "<div style=\"background-color:red;\"> Urgent</div>", [YTD Change-Incoming to Answer] )
------------------------------
Courtneah Thomas
------------------------------
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.