-
Counting number of contacts in a cell, "Allow Multiple Contacts"
Hello. I'm trying to count the number of people (contacts) who appear in cells in a contact list column, where I allow multiple contacts. Using a COUNT function always returns "1", independent of how many contacts are in a given cell. I'm not looking to return how many times any specific person appears, only to count how…
-
Meeting Recording
Hello Admins, I attended session on "Intro to WorkApps" occurred on December 08 2021. Can anyone send the session recording video?
-
Failed 3 attempts on Introduction to Dashboards training
Good day all, i failed 3 attempts on the introduction to dashboards training, can you tell me if after 24h it will be reset and i will be able to do it again? Or if not how it works? Thanks
-
Alert Someone Notifications not Working
Hi! I am running into an issue where my 'alert someone' notifications are not sending. I have a column that is formatted as a contact list, and my automation is set up to alert the email chosen in that contact list. However, the emails are not being sent. When I test it with myself, I DO receive the alert via email, when I…
-
How am I misunderstanding the CSV formatting for importing contacts?
The Manage Contacts in the My Smartsheet Contacts List article says that the csv should have three columns, First Name, Last Name, and Email Address, but then an example is provided with two columns - Name and Email Address. Am I reading this wrong?
-
Creating a Group
Hi I want to give my whole firm access to a particular smartsheet item. Is there a way to bulk upload contacts into a group without any additional add-ins / different licence? I have access to our admin centre and have created the group I want however, when it comes to adding to the group it only gives me the option to add…
-
Contact Card email address fo automation
Hi All, I have a sheet where customers send a submission and get automated emails with field data that they submitted. I want to provide details of the assignee of their submission but want to provide the assignees email address stated on their contact card - is there any way of doing this? I currently grab field data by…
-
Copying contact information from one sheet to another
If my users attempt to copy contacts from one sheet to another, they loose the total contact information. Only the name, as text comes over. Even if both column types are Contact. There does not seem to be an easy way to copy over a list of contacts. Using copy rows is not an option - because the messes up the formulas…
-
Can I create a "No-Reply" user within Smartsheet to send external forms?
I am creating several forms and automated email alerts that will go to external resources and I do not want my name attached. Could I possibly create a "No-Reply" user in Smartsheet and transfer the sheets to this user? I understand the "No-Reply" user would require a license which is not a problem.
-
COUNTIF Formula for Contact Column
I have several tasks set up for team members using their email addresses in the Contact column. Some tasks have 1 member assigned and some have multiple. I have to run each person's workload and am trying to use a separate sheet that counts the number of times their email address is in the Contact column. However, the…
