Forum Discussion
Filter Function with "Not Contains"
Hi All, Any help would be appreciated I already have a formula in place , I just want to add third condition to this: First Condition : - if status =1 Second Condition : - Total time for same A v...
ahmedoye
Responsive Resident
Responsive ResidentHi, you can modify the Filter side of your formula as below:
Filter(Table1, status=1 && Total Time>5 min &&
(FIND("ACL", Table1[C], 1, 0) = 0 || FIND("BCL", Table1[C], 1, 0) = 0))
If this works for you, kindly mark as solution to make it easier for anyone with similar challenges find the solution.
If this works for you, kindly mark as solution to make it easier for anyone with similar challenges find the solution.
ahmedoye thanks for replying but I think we need to add one more condition to it saying for same "A" value