I have a table of sales orders keyed by sales order number. I often get sent spreadsheets with lists of sales orders with the question "What is the state of these?" I'd like to be able to take that list, enter it, and get the lines back for the match...
Is there a way to conditionally format text ? I have metrics that I want to report on, each has a field that show the status “Good” “Warn” “Poor” … it would be great to color the field on the report based on this.
Related but now … How do I get a cha...
I have a rollup column in an aggregate table where I want to get a percentage. In the original record, I am recording 1, 0, or empty.
The basic components work … SUM(values) returns “6” … COUNTA(values) returns “8”
But … SUM(values)/COUNTA(values)...
Thanks that worked. I had issues with scaling items from a pic list, so I didn’t try this … the scale with the font size should someone else care later.
