Skip to main content

Hello. I suck at formulas and need some help.



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.



Can anyone please help me with this?

Sorry you’re feeling the struggle. That’s all very do-able. Here’s a quick example to get you started:



AND(


    OR({field1}="received",{field1}="not needed"),


    OR({field2}="received",{field2}="not needed"),


    OR({field3}="received",{field3}="not needed"),


    OR({field4}="received",{field4}="not needed")


)


That should automatically return 1 or 0. If you end up wanting to use words instead of digits, you could put that whole thing in an IF block like this:



IF( all that stuff you just saw, "some word", "some other word")


Best of luck!

Reply


Terms & Conditions