Duplicates

Joey Razzano

Joey Razzano ✭✭✭✭

01/19/21 in Formulas and Functions

Is there a formula to count the number of duplicates in a column?

0 ·

Answers

Chris Mazuran ✭✭

01/19/21

This might help...https://community.smartsheet.com/discussion/4007/identifying-duplicates-within-a-column

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

Is there a FORM ID?
I have multiple forms that can be used to submit data to a worksheet, and I'm wondering if there is a FORM ID that could be used in a column so I know which form was submitted. If yes, is there a specific formula I can use in a column to identify the Form ID and Name of the form?
Index/Match Formula Behavior
Hello, I'm encountering an issue with the INDEX/MATCH function. When the value in the cell being match does not find a match and is recognized as text rather than a number, the formula does not return 'no match' as expected. Instead, it displays the last entry in the reference range. Formula in cell Category Index/Match…
"Boolean Expected" Error
Hello All, I spent a few hours building an equation (I am not an expert) within a sheet that reads another main sheet. =IFERROR(INDEX(COLLECT({GenFertCalc}, {Client Name}, [Client Name]@row, {Tones}, "Granular Fertilizer (Tone)"), 1), 0) The error message "Boolean Expected" occurs in the correct cells, but instead of…