Count How Many Times a Value Appears in the Column
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

@Bethany Garcia Yes, that is doable. You'd need to use COUNTIF() or COUNTIFS() and count the number of times the value in a given row appears over the whole column range. You'd then check to see if the resulting value of the count is >1
Darren Mullen, smartsheetguru.com
Get my 7 Smartsheet tips here
Author of: Smartsheet Architecture Solutions
Help Article Resources
Categories
Check out the Formula Handbook template!