Hello everyone,
I want to filter my gallery by 2 different "statuses".
Status 1: "Open"
Status 2: "In progress"
The database is a SharePoint list and the formatting is set as TEXT.
If I filter by a status with my formula it works.
Gallery Items:
Filter(
RCA_Entries;
StartsWith(
Abteilung;
"QM"
);
StartsWith(
Linie;
Label62.Text
);
StartsWith(
Status;
"Offen"
);
StartsWith(
Status;
"In Bearbeitung"
)
)
Solved! Go to Solution.
Filter(
RCA_Entries;
StartsWith(
Abteilung;
"QM"
);
StartsWith(
Linie;
Label62.Text
);
StartsWith(
Status;
"Offen"
)Or
StartsWith(
Status;
"In Bearbeitung"
)
)
Filter(
RCA_Entries;
StartsWith(
Abteilung;
"QM"
);
StartsWith(
Linie;
Label62.Text
);
StartsWith(
Status;
"Offen"
)Or
StartsWith(
Status;
"In Bearbeitung"
)
)
User | Count |
---|---|
164 | |
91 | |
67 | |
64 | |
63 |
User | Count |
---|---|
211 | |
157 | |
93 | |
81 | |
71 |