Contact list column not working in a sheet

LyndaRousseau

I have a weird problem…

In one of my sheets, I have 2 contact list's columns and one of them doesn't work. ??

I'm ADMINISTRATOR with a licence of this sheet.

Tx !!

Paul Newcome

What exactly do you mean by "it doesn't work"?

LyndaRousseau

Oups ! Sorry it wasn't clear at all ! 🙃

In that column, when I'm typing a name in a cell, I don't get the list of contacts suggestions. So it's like typing in a Text/Number column.

Here is what I see in the contact list column that it working:

And what I get in the contact list column that doesn't work:

Thanks a lot !!

Paul Newcome

Are you able to provide screenshots of both of the columns' column properties?

LyndaRousseau

Hi @Paul Newcome !

Here is a screenshot of the column that works fine:

Here is a screenshot of the column that DOESN'T work:

It's configured exactly the same way in other sheets and it work perfectly. Only this one sheet that doesn't work.

The only difference I found was that I'm ADMIN and not OWNER of this sheet.

Thanks a lot !!!

Paul Newcome

Try lifting the restriction. You have the field set to be restricted to only allow users to select people that are listed in the column properties, but you have no one listed in the column properties.

LyndaRousseau

@Paul Newcome

…Feeling so silly… I was convince 100% that I had configured all my sheets the same way. I just don't know why I activated that restriction. 🤦

Oh welll !! Thanks for helping me ! 🤩

Have a great weekend ! 😊

Paul Newcome

Happy to help. 👍️