Hey, I have a list of items (item 1, item 2, item 3). I want to subtract another list so that I only return the difference of sets (item 1, item 2, item 3) - (item 1, item 3) = item 2.
Is there a way to do this in Coda?
Hey, I have a list of items (item 1, item 2, item 3). I want to subtract another list so that I only return the difference of sets (item 1, item 2, item 3) - (item 1, item 3) = item 2.
Is there a way to do this in Coda?
Hello Matt! Yes there is!
If you want all the values that don’t match, you can use this formula:
List1.Filter(CurrentValue.Contains([List 2]).Not())
Thanks, worked perfectly.