Conditional Formatting Issue

Discussion created by jjscarpetta on Sep 2, 2016
Latest reply on Sep 2, 2016 by jjscarpetta


Mac OS 10.11.6

MacBook Pro


I have an issue where conditional formatting in a file I am working in is evaluating from the bottom to top instead of top to bottom. I have 2 fields, one called status ( text ) and the other called flag_invoice ( number ) . When an invoice is created it sets the flag_invoice to 1 so attached images show the conditional formatting and the output. If the status is "Open" it fills orange and invoiced fills green. Previously the status field wasn't being set to "Invoiced" but since that has been updated this isn't a problem with this scenario.


I have tried it with another table in the file and choosing to random fields to add formatting on the button with the same results. I have not tested this in a another file as of yet.


Screen Shot 2016-09-02 at 6.53.48 AM.pngScreen Shot 2016-09-02 at 6.54.42 AM.png