Unique Values Filter

benhamilton1
benhamilton1 ✭✭✭
edited 08/05/24 in Formulas and Functions

It would be very nice is much like blank or not blank or contains or does not contain there was a filter for a column that allowed you to select only unique values.

Tags:
· Share on FacebookShare on Twitter

Answers

  • Rich Coles
    Rich Coles ✭✭✭✭✭

    You could achieve this by adding a column that you apply a filter to that counts the number of times an item appears in a list. Keeping it really simple, if you had a formula along the lines of =COUNTIF(Item:Item, Item@row), any value that is 1 is unique

    Rich Coles

    Prodactive | Smartsheet-aligned Platinum partners

    Check out our Smartsheet-dedicated YouTube channel for tips, tricks and inspiration

    · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!