Highlight repeating instances in a column

Hi there!
I’d like to highlight many instances in a column when in that column you have a word that’s repeated more than once. Like I show in this picture.

This spreadsheet is to order my duties at work. Open tickets and categorizing them.

I’m reading the help of AppSheet but all test get me an error. And then I said: “May be is time to get some help” :o)

Thank you for you effort,

Regards

Julio Anguita
(from Buenos Aires)

You’d probably want to use format rules to provide the highlighting:

Please post a screenshot of an expression that gave you an error, including the error if possible.

Hi Steve,

is not what I need.
I need a formula to set it in condition formatting.

3X_6_f_6f4f7e91747df82c1bb26d630af019bbc962d295.png

And tell to the AppSheet to highlight words that repetead more than once. In Excel or Google Sheets you can use a CountIF. Here I don’t figure it out how to do it.

Thanks,

Julio

Steve,

I’m going to use the Calendar View to see all the things that I need to see at once.
It’s easier.

Thanks!

Julio

2 Likes

COUNT(SELECT(contacto[nombre], [_THISROW].[nombre]=[nombre]))>1