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("<"…
We have multiple projects, each with their own project plan sheet. On each sheet we have the usual project plan columns, Start Date, End Date, Duration etc. We also have an Assignee (resource) column …
When using Assigned To or any other contact field across a large number of sheets, and then aggregating that data in a report or pivot that groups by the contact field, it becomes quickly painful that…
I started a Smartsheet trial yesterday. What I really need is to be able to SPEAK to someone personally about this application! There is no contact number available for "trial users". One found on Goo…
I need help with a formula. Since there is no way to cross-check against a group in a sheet, I have created a sheet listing all users of a particular group and am trying to use a cross-sheet reference…
I am running into an issue where I import a group of names assigned to a certain task in Smartsheet. The list of names comes from an excel spreadsheet as multiple agencies must provide their inputs an…
I've noticed this request a few times over the years, but still don't see that Smartsheet has addressed this. When using sheets, the "Contact List" column works wonderfully and will populate any user …
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 sett…
There needs to be a workflow that allows a user to select a contacts column and be able to copy/paste (or otherwise transfer) the values into group management. The current settings do not allow one to…
Hi, I feel like I am eating crazy pills here, but is there really no way to copy contacts in a Smartsheet worksheet contact column into a Smartsheet contact group without jumping through insane workar…