I am working on a start expression used to filter a report.
Note the report worked perfectly when its filter was just to grab the data from the table and order it.
Now I am trying to remove some potential rows from this report.
Here is the Expression:
As you can see I am creating requirements for the rows.
One is tha the length of the name in Equipment is equal to or less than 3.
This works correctly as tested by itself.
My next step was to remove specific results, I attempted this by creating and AND( in the select row portion of the filter expression. For some reason this fails and I cannot work it out.
Appsheet is telling me this expression does not produce a list of ref values?