Not sure if I categorized this correctly, but here is my situation. I have an app for submitting a security request for employees. There are levels of the security request that are handled by different individuals. I would like each individual to mark their โsectionโ done, but not set the status of the request to โcompleteโ until all required sections are completed.
Here are the sections that are possible:
Not all programs will be selected for each request. Letโs say that just Google and JDE are selected for this particular request. I need to mark the request complete when Google is marked DONE AND JDE is marked DONE, but disregard the other programs.
I am pretty sure I need an AND and an OR, but not sure how to say to only look at the program if it is in the listโฆhere it is in Englishโฆ
If GSuite is in the list for Programs and GSuite has been marked complete AND
If JDE is in the list for Programs and JDE has been marked complete AND, etc. (for all programs)
However, what if GSuite is NOT in the list (not selected), then donโt even look at that, just look at the ones that ARE in the list to see if they are marked DONE.
This is what I am thinking (but need something for the DOESNOTCONTAINS):
AND(
OR(
AND(CONTAINS([Programs],โGSuiteโ),
[GoogleComplete]=โDoneโ),
DOESNOTCONTAINS([Programs],โGsuiteโ),
)
OR
AND(CONTAINS([Programs],โJDEโ),
[JDEComplete]=โDoneโ,
DOESNOTCONTAINS(Programs],โJDEโ)
)
NOT(
CONTAINS(
...
...
)
)
Oooh thanks for the quick replyโฆgoing to try itโฆwill let you know.
Youโre very welcome.
Thanks Steve!
Okay, here is what I have come up with, thanks to your help:
AND(
OR(
AND(CONTAINS([Programs],โGSuiteโ),
[GoogleComplete]=โDoneโ),
NOT(CONTAINS([Programs],โGSuiteโ))
),
OR(
AND(CONTAINS([Programs],โJDEโ),
[JDEComplete]=โDoneโ),
NOT(CONTAINS([Programs],โJDEโ))
)
)
This is what AppSheet is summarizing:
ALL these statements are true:
โฆ1: ANY of these statements is true:
โฆ1: ALL these statements are true:
โฆ1: (The value of column โProgramsโ) contains the text value (โGSuiteโ)
โฆ2: (The value of column โGoogleCompleteโ) is equal to (โDoneโ)
โฆ2: This statement is false:
โฆ(The value of column โProgramsโ) contains the text value (โGSuiteโ)
โฆ2: ANY of these statements is true:
โฆ1: ALL these statements are true:
โฆ1: (The value of column โProgramsโ) contains the text value (โJDEโ)
โฆ2: (The value of column โJDECompleteโ) is equal to (โDoneโ)
โฆ2: This statement is false:
โฆ(The value of column โProgramsโ) contains the text value (โJDEโ)
Now I just need to add all the other programs.
Thanks again for the fast response and help!
A note on CONTAINS()โฆ
But since youโre using an enumlist, IN() will be more efficient.
User | Count |
---|---|
43 | |
26 | |
23 | |
14 | |
11 |