Get a distinct set of values from an existing column without changing order.


I am trying to get list of values that has each value only once. Below I have my JOB NUMBER column and I am trying to create an automatically updating column that we will call DISTINCT NUMBER that lists each number once. The catch is that the JOB NUMBER column is always changing and I want the DISTINCT NUMBER column to keep its order and add all new values to the end of the list. This is because I am using the DISTINCT NUMBER column for my team to place their emails after. If the DISTINCT NUMBER column changes order, then the link between the email and number will change.

Let me know if you have any ideas.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!