Forum Discussion
Filtering rows based on a lookup match
Hello everyone,
Here's my table 'Approvals':
Index
Submitter
Submitted_datetime
Status
Approved_datetime
FileID
1
Anne <removed by Admin>
4/1/2020 13:00
Pending
...
Can there be multiple approvals? If not then you can simply show all rows where FileID is blank or status is approved.
Perhaps if you post a bit more sample data, it would help understanding the use case.