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?

Best Answer



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!