Conditional Formatting on List View Breaks with Hidden Columns
Interesting behavior: Conditional Formatting in SharePoint Designer requires that any fields used in the condition be shown in the view. But what if you are using calculated values as placeholders for formulas in the condition? You probably do not want to view these. They are like temporary variables used to derive an end result, as developers we only display intermediate variables usually when we are debugging. Once we have it working we only show inputs and outputs. Example: Let us suppose you have been tasked to create a colorful list view that shows a due date as different colors depending on how far away the due date is. The formatting is: (background color, bold font, larger font, border solid, white, medium top/bottom 20px left/right, padding top/bottom 3px, text-align center) Due Date = RED if Due Date is past or Today. Due Date = ORANGE if Due Date is 0-30 Days in future. Due Date = YELLOW if Due Date is 30-60 Days in future. Due Date = G