I have three portals on a layout that display data from the same table, each filtered differently. The portal specify formula for each one is a version of:
"Not IsEmpty(field1) and Not IsEmpty(field2) and Not IsEmpty(field3) and IsEmpty (field4) and IsEmpty (field5)"
It works fine but feels inelegant and clunky to me. Is there a better way?