We’re trying to figure out of we can create a setup wherein IF uses a particular Collection if certain cells have content in a spreadsheet. So, for example, let’s say our spreadsheet columns/criteria are A, B, and C.
- If a row contains content in cell A only, we want IF to use Collection #1.
- If a row contains content in cells A and B, use Collection #2.
- (skipping ahead) If a row contains B and C, use Collection #5.
We aren’t seeing yet if Conditional Triggers can handle this, and we’ve also wondered if an Excel formula could help. Any ideas?