I have two collections that both use the same ID. I want to use a formula like remove if to remove all the items from the first collection that are also in the second collection.
Example:
Collection #1
| ID | Data |
| 1 | A |
| 2 | A |
| 3 | A |
| 4 | B |
| 5 | B |
Collection #2
| ID | Data |
| 1 | A |
| 3 | A |
| 5 | B |
Desired result:
| ID | Data |
| 2 | A |
| 4 | B |

Report
All responses (
Answers (