Automation Not Allowing Alerts to Contacts in Specific Fields + Form Not Adding Lines to the Sheet

Courtney Davis

Hello,

I have a 2-fold issue with my Smartsheet. I'm setting up workflow automation, and it's only allowing me to alert one type of contact. See below. I am trying to also add an alert for the registration member assigned to the project.

Additionally, I submitted a test form submission over an hour ago, and it's still not showing up on the sheet. How long does it usually take to populate?

Andrée Starå

Hi @Courtney

I hope you're well and safe!

Have a look at the bottom of the sheet to see if the row got added there.

Also, check the permission settings for the Workflow.

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Courtney Davis

Hello, thank you for your quick response! You are right. The line did get added to the bottom of the sheet. Line 1104. How do I get form submissions to add to the next available line? In this case, I've only used Line 1, so I'd like the form to add in consecutive order.

I updated the workflow permissions to Unrestricted, but I am still only given the one option for alerts.

Andrée Starå

@Courtney

Happy to help!

Try deleting all rows because they are probably "activated".

Can you maybe share some screenshots of the alert? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@workbold.com)

Courtney Davis

The deleting the rows worked. Thank you!

This is the screenshot for the alert I'm trying to create. Where it says send to contacts in a cell, it's only showing the one column as an option.

Also, can you please tell me why this field is showing up like this? instead of regular text?

Andrée Starå

@Courtney

Excellent!

You're more than welcome!

The Registration column doesn't look like a Contact Column (or maybe it's a multi-select?), but a Drop Down list type column, which is why it looks like it does and why you can select it in the Workflow.

Was that the issue?

Courtney Davis

So the reg column is a multi-dropdown and not a Contact column! That fixed it! Thank you!

Andrée Starå

@Courtney Davis

Excellent!

You're more than welcome!

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!