-
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…
-
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…
-
Pulling a List of Names to a Preferred Contact List
I need to maintain hundreds of log sheets. On the sheet, we use a Contact List column with a preferred contact list. On the form, we use radio buttons to easily select from the list. While this system works well, I've come across a limitation: when we have personnel changes, I need to change the preferred contact list on…
-
Issue With Smart Sheets Forms Automation, and Data not Being Recorded in the Right Row!
Good day! i'm facing a weird issue with smart sheets automations, I have created a form on smart sheets and the questions were linked to the sheet columns normally i created a column of email contacts list to run the automations over, and the idea was that whoever gets this form link to fill from this email list, will fill…
-
BRIDGE/API: Add Users to Group from Sheet?
Hey Y'all! I'M STUCK on the next step for my Bridge solution. I'm simply trying to add members to a group named "GroupTest" if the [Approval Status] in this sheet (image below) gets marked as "Approved", but only if it's not already in the group. Eventually, I also need to have the status of "REJECT" remove them from the…
-
How to extract email address from a contact list the use the value in an adjacent column
Up until now, I have copied/pasted the email address manually. Nevertheless, our database has grown so much. I've tried the below formula: =IFERROR(SUBSTITUTE(SUBSTITUTE(MID([🎓 Student]@row, FIND("<", [🎓 Student]@row) + 1, FIND(">", [🎓 Student]@row) - FIND("<", [🎓 Student]@row) - 1), "<", ""), ">", ""), "") but after…