Filter distinct values only into new column

Answers

KLZolali ✭✭✭

01/19/24

https://community.smartsheet.com/discussion/comment/414505#Comment_414505

@Paul Newcome I had the helper column on the referenced sheet and not the sheet with my formula. That was the issue. Thank you!!

0 · Share on Facebook Share on Twitter
KLZolali ✭✭✭

03/06/24

@Paul Newcome Ah - that was the issue. I didn't have the helper column on the right sheet. Thank you!

0 · Share on Facebook Share 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!

Trending in Formulas and Functions

Working with dynamic cumulative fractions
I am trying to create pareto charts for dashboards. I am referencing a sheet where I create totals and counts etc. One is a count of total items in a team. Impact =(Count@row / (SUM(CHILDREN(Count$2))) to get percentage for items for each team overall. Cumulative is for Pareto charts =SUMIFS(Impact$3:Impact$20,…
Returning cell based on 2 criteria in another sheet
Hi, I'm back! I am trying to pull the course cell per semester based on a student's ID and also on the Term (fall or spring) columns. This sheet is my "eligibility sheet" where I would like the course from my Active TAships sheet to go Active TAships Sheet: The formula I am using in the FA Acceptance (also will be in Sp…
Checking off a box in one form when another is filled out?
Hello! I am very, very new to Smartsheet so please forgive me if this isn't the right place to ask or a dumb question. I am attempting to make a sheet that records when someone has filled out a form on another sheet. The original sheet is a form for a customer service survey, and the one I want to make records when and if…