Hi,
In a filter View, I have a couple of filters. On of them is addressing Chord Progressions (music). These are listed in Roman Figures (I, II, III, IV, but also in low case: i, ii, bvii and so on).
The filter I use is this:
IF(ISBLANK(ANY(FILTERSONG[ChordProgressions])), TRUE, ISNOTBLANK(INTERSECT(SPLIT([Chord Prog], ","),
SPLIT(ANY(FILTERSONG[ChordProgressions]), ",")))),
I just found out that the progression vi-IV-I-V results in 2 songs that make use of this progression, at least, they are very close: vi-IV-i-V and vi-IV-I-V. Obviously I need to do something with the formula to avoid this problem.
In Google Sheets I use EXACT, but this is not available in Appsheet. Any advice?
Regards, Andrรฉ
Could you update what are the types of columns [Progressions] and [ChordProgressions] in the respective tables Filter Setting table and Main table that you are trying to filter?
User | Count |
---|---|
17 | |
14 | |
8 | |
7 | |
4 |