For JOIN(DISTINCT(COLLECT formula, can you create exemptions?
I am trying to use a JOIN(DISTINCT(COLLECT formula that is working to target all the items in the range; however, I am needing to focus the data to show only three of the items from that range OR to create an exemption to remove one specific item from the range. Is this possible? Or is another formula needed to capture an exemption?
Help Article Resources
Check out the Formula Handbook template!