Welcome!

Count number of Values Selected on a Contact list

tfassnacht

Good morning,

I have a column which is a contact list.

My contact list is populated with users and email adresses.

I'm willing to know the number of assigned people (i.e. for a given task, how many Values Selected on a Contact list).

When I use count, it erroneously returns one (if one or more values are selected).

Is there a way to get the correct value ?

Sincerely

Find more posts tagged with

Comments

Andrée Starå

Hi,

Unfortunately, as far as I know, it's not possible at the moment, but it's a great idea!

Please submit an Enhancement Request when you have a moment.

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Paul Newcome

Is it set up to where you can put multiple contacts in one cell? If so, you could use a helper column to count how many are in each on a row by row basis and then sum that helper column.

Andrée Starå

Paul,

Duh! Yes! I was only thinking about the count of the column. Helpers were sleeping!

Best,

Andrée

Paul Newcome

Hahaha! Gotta love when the helpers are sleeping on the job...

tfassnacht

It's a poor way around the issue.

If you got 10 persons asigned to a task, you don't want 10 rows.

Andrée Starå

You don't need ten rows. That row with the 10 contacts would show 10 in the helper column.

Would that work?

Best,

Andrée

tfassnacht

I don't know what a helper is.

See enclosed. My resources are cars in this concept (they are still registered as Users in SS).

Tasks are "Events".

When I have Car1 and Car2 assigned to a task, I would like a formula to return 2 (as 2 cars are used for this task).

Thanks

tfassnacht

Can s.o. respond ? Thanks.

Andrée Starå

Hi Thomas,

Missed your answer. Did you solve this?

Best,

Andrée

Manish Govindji

Hello,

I am looking for exact same formula, is there any work around?

Thank you.

Pat Canning

NbCars@row =COUNTM(Cars@row)

Sign in to join the conversation!

Quick Links

Trending discussions

Sharing with Editors outside our company
Good afternoon! My company works closely with another ambulance service, Company B. Both companies have a Smartsheet Enterprise plan. I have created a workspace that I need members of Company B to edit. Do I need to make them members on my account if they are already members on their account? Or do I just need to add their…
How to create stack column graph bars
I'm trying to create a graph chart that captures monthly count of records by divisions (Northeast, West and Central) that should be stacked with a legend displaying each by different color like a presented in Excel. When I attempt to duplicate the process in Smartsheet I receive the following results. In Excel, I created…
Can an admin of a sheet be from a different organization?
I have shared sheets and dashboards with people outside of my organization, and one has a paid license. Would I be able to grant admin access to this licensed user to their sheet? Or would the ownership of the space by one organization limit the admin accessibility of someone from outside?