System: Created By as Contact List?

I have a form that's only accessible to registered Smartsheet users. I believe that means that the System: Created By field will always be an email address.

In that case, is it possible to use the System: Created By column as a Contact List for things like Notifications and Update Requests? That would be more efficient and accurate (w/o typos) than requiring people using the form to type in their email address.

If not, please consider adding this functionality.

Find more posts tagged with

Contacts

Update Requests

Email Notifications

Comments

Andrée Starå

Hi Jeff,

It's possible. I remembered incorrectly.

Unfortunately, it's not possible but great idea.

Please submit an Enhancement Request when you have a moment.

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Mike Wilday

I second Andree's notion. That would be a good enhancement. Please submit!

Daniel Stein

Hi Jeff,

If you have a "created by" system column set up, you can indeed use that as a recipient for notifications and update requests, just like a contact column; there's no need to actually make it a contact column. This can be very useful if you want to automatically send update requests or notifications to the person who submitted the form. Since you are requiring Smartsheet login to submit the form, there is no need for the user to enter their email address, because it will be populated automatically in the system column.

So if I'm understanding you correctly, it's already possible to accomplish what you are asking. But please let us know and provide additional detail if I'm misunderstanding you.

Thanks!

Daniel

JeffG

Possibly I need to report a bug then. Because Smartsheet does indeed let me choose the Created By column for Alerts, etc. (see attached Alerts.jpg - top image)

But then I receive an email stating the recipient is invalid (see attached Email.jpg - bottom image)

It seems sharing the sheet with whoever filled out the form alleviates the issue, but I don't want to share the sheet with everybody that fills out the form or could fill out the form. Also I don't want my internal process visible to that many people.

Andrée Starå

Yes, of course, it's possible. I remembered incorrectly. Sorry about that!

To get it working you'll have to choose a less restrictive sharing setting in the Alerts & Actions Permissions section that you'll find in the Alerts & Actions overview (cog in the top right).

Did that do the trick?

Best,

Andrée

JeffG

That did it, thanks everyone for your help!

Looking back at the "Invalid recipients" emails I see now I clearly wasn't understanding the first line.

1. Check your Alerts & Actions Permissions. Open the Alerts & Actions menu at the top of your sheet and select Manage Alerts & Actions. Click the Settings icon to modify permission levels to include the invalid recipients.

Perhaps some additional clarification for the Settings icon (cog in the top right, like Andree pointed out) would be helpful? I had never even noticed the cog.

Sign in to join the conversation!

Quick Links

Trending discussions

How do I make a form field's visibility dependent on 2 fields?
Hi, I've been struggling with this with my favourite AI for over an hour now and I've hit a wall. I want to implement the following: if [CheckboxA] show field 1 if [CheckboxB] show field 2 if [CheckboxA and CheckboxB] show field 3 There is no way to do this within SmartSheet forms. You have to have a helper column in the…
Make Rows From "Active Projects" Sheet Transfer to Another Sheet ("Invoicing") Upon Job Completion
My company uses Smartsheet on an extremely rudimentary level. We are not tech savvy; we are tragically behind. We have only figured out to use one automation so far, which is when a new cabinet-related "project" gets automatically added to our "Active Projects" sheet from our "Sales Pipeline" sheet. But we have a major…
Smartsheet Help
Hi Smartsheet community! I am looking for guidance on best approach to create an individual tactical plan w/ embedded milestones and general timeline that rolls up into a Team tactical plan w/ milestones/timeline. Hoping for functionality where individuals are notified a milestone dates and progress to goal is tracked at…