I am trying to pull a list of unique values from one sheet to another

Options

I am trying to pull in a list of distinct values to sum. I have a sheet with a project number, date, and a value (project id, date, amount) and I have merged all of those together for a helper column. Now I want to pull that helper column's distinct values into another sheet once. The original sheet may have the values listed multiple times.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!