MaeDahl
Qrew Member
Joined 6 years ago
User Profile
User Widgets
Contributions
Re: Change Text Color based on condition
Thank you Justin, This works if I setup a separate field however I'd like to turn the actual number field listed under "Total Items Fulfilled" "Green" when the number matches the Total Items requested. @Mae Dahl This should work, I've made some assumptions about the names of your fields. If( [Total Items Requested] = [Total Items Fufilled], "Green", [Total Items Fufilled] < [Total Items Requested], "Yellow", "" ) ------------------------------ Justin Torrence Quickbase Expert, Jaybird Technologies jtorrence@jaybirdtechnologies.com https://www.jaybirdtechnologies.com/Change Text Color based on condition
I have a report that reflects Total Items Requested; Total Confirmed Ordered; and Total Fulfilled(shipped). IF Requested = Fulfilled I'd like the value to show Green IF Fulfilled < Requested then show value in Yellow Appreciate the guidance. Mae Dahl ------------------------------ Mae Dahl ------------------------------
