Here is my "formula" in layman's terms...
Case([Job - Projected Start Date]<Today()AND [Completed by:]="CHOOSE SUB",RED)
please fix so that it works. thx
------------------------------
Lynne8817 Lynne8817
------------------------------
Question
Need to colorize a row in report
+11
+22IF([Job - Projected Start Date] < Today() AND [Completed by:] = "CHOOSE SUB", "FFAEB9") // this will be pink
IF([Job - Projected Start Date] < Today() AND [Completed by:] = "CHOOSE SUB", "red ") // this would be red
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
IF([Job - Projected Start Date] < Today() AND [Completed by:] = "CHOOSE SUB", "red ") // this would be red
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
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.