This is probably documented elsewhere but we weren’t aware of it until a few days ago, so I thought I’d post it as a quick tip.

Have you ever looked at a SmartList of inventory quantities…

AllSites1

…then wanted to isolate only the rows showing total quantities (the rows labeled “All Sites”)?

Setting the filter to match All Sites

But trying to match “All Sites” shows no rows.

Shows no rows

The trick is to match on a blank field, not the phrase “All Sites.”

Matching on a blank field

That shows the rows we want.

Shows only the "all sites" rows

In the underlying database, the “All Sites” rows are coded using an empty field.

Aha!

Hope this helps someone!

Leave a Reply

Your email address will not be published. Required fields are marked *

 characters available