-
Automation adding contacts to a sheet from another (not dropdown)
For each project, we have a 'team list' sheet that shows up on the project dashboard. The team list uses cell links from our master employee list, so by entering the name, it automatically shows their phone number, department, etc. In theory, it should be updated at project kickoff and periodically throughout. It never…
-
Merged: Form input translating to a contact in a contact list
This discussion has been merged.
-
Multi Contact Column with Automations
Hi all, I have a multi choice contact column that has a simple formula that looks at a country column and based on the country returns multiple emails per country, so lets say that column country is France i have the contact column return three contacts, so far it's fine but it doesn't work when i try to use an automation…
-
Populate a contacts drop down list when adding a new user to a group.
We have a sheet with a contact list drop down. What we would like to do is have the user's first and last name with their email address added to this drop down list when the account is created and added to the Everyone group. Has anyone else looked at this option?
-
Deactivate the Share function of AI recommended persons
When sharing a workspace or individual asset, there is a new feature where AI recommends people underneath the box "Invite People and Groups". Is it just our company, or is it 99.9% WRONG in your environment, too? We have over 12k users, and the AI recommendations are an annoying distraction, especially because they are…
-
Populating Contact List Dropdown Automatically
We have one sheet where we would like to populate a contact list drop down automatically when they are added to the everyone group. We would want the first and last name and their email. I know this has been discussed many time but still not available. Has anyone been able to make this work somehow without involving a…
-
Set Users from User Management list as dynamic Contact List
Seeking the ability to set the Users from User Management to be an available option to be the population for a Contact List in a dynamic fashion. In this, if a user is added to User Management, they are also added to a Contact List. Other competitive offerings like Atlassian/JIRA allow for this. Now, from a Grid view, you…
-
Contact Name Displaying as Email
Ok so.... We have a Smartsheet form that we use to stand up project files in Control Center. When we ask for Contact information it's set up with email validation. Our PMs have said they do not like that that it doesn't say the contact name. For example instead of "John Smith", it displays "john.smith@abc.com". Is there a…
-
CountIFS contact is in a contact list
=COUNTIFS({TEST Range 1}, ="*Name*", {TEST Range 6}, ="DO") Hi all, this is a helper sheet used to get the counts of different conditions. Test Range 1 is a contact list that can contain multiple contacts, how can i make it so that i can check if "Name" is in the list. It is currently returning 0 when it should be finding…
-
Why isn't my email notification being sent?
I have an automated workflow set up to alert someone (several people), triggered to run once at a specific time. I need it sent to notify people to complete a form. I tested it several times when setting the sheet up by sending it to myself, but now that it's live and is supposed to go out to several people it's not…