I'm building a dynamic dashboard with multiple filters. I'm making a Index/Collect formula that can read values on a source sheet based on the values selected via the filters. This formula should work and I've seen it work on other sheets that Pro-desk helped with, and they gave me, but for some reason, I'm getting a #INCORRECT ARGUMENT SET error.
=INDEX(COLLECT({Budget Sheet A-USD}, {Budget Sheet A-Season}, {Selected Season}, {Budget Sheet A-Campaign}, [Primary Column]$2), 1)
Does anyone have any thoughts/ideas on what might be causing this error with this INDEX/COLLECT formula? I feel like it may be a syntax error but I'm not quite sure what it would be.