Count How Many Times a Value Appears in the Column

Options

I have a column that contains a value (Example: "Joe@email.com:iPhone", "Joe@email.com:iPad"), and I want to have a formula check to see if any value in the column appears more than once, or to just tell me how many times the value in that row appears throughout the column. So in the provided example, if those two values are in the column one time, I would want to see a True or False (depending on whether the formula is indicating that there is or isn't a match), or to see a number indicating how many times that value exists in the column.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!