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

Are You Able to Join Two Columns into a Data Shuttle Dynamic Dropdown?
Hi everyone, I'm hoping someone here can help me out with a challenge I'm facing in Smartsheet's Data Shuttle. I've been trying to use expressions to combine two columns into a single dynamic dropdown column in a target sheet, without changing the source sheet. For example, I want to combine Num and Name into a format like…
Converting email addresses with hyphenated First and/or Last Names
I am trying to convert email addresses into a Name field with the employee's First and Last Name, capitalizing the first character of each part of the name and keeping the hyphen in any part of the name that has one. I started with hyphenated first names so taking shmoe_joe-bob@company.com and converting it into Joe-Bob…
How to count a field which has a certain character in it.
I have a field with the date formatted as 09/30/2024. I would like to summarize that field with the count of lines containing 09 and 2024 (so basically by the month and year). I am attempting just for the month and can not get it to work. =COUNTIFS([Next Renewal Date]:[Next Renewal Date], CONTAINS("09") But I would also…