I have 4 single select fields in which I set the status of different documents I collect from clients (not sent, sent, received, not needed). I then have a “document status” formula field that queries the status of all 4 single selects.
I want the document status formula to display “1” if all fields indicate “received” OR “not needed”. It should return a “0” if any other combination is shown.
The purpose of this is to allow me to use a gallery view that filters for “document status = 0” and show me only the clients that owe me documents.