-
System deleted an automation?
We had an automation set up on a sheet to send a notification to a Teams channel when there are rows added via a form user. This morning one of my colleagues got an email from system.smartsheet.com stating the automation was disabled because one or more blocks in the workflow was invalid. We opened the Automation menu in…
-
Recurring Workflows - configure a workflow with a time-based trigger
Hi All, Great news! I just got a message that Recurring Workflows are coming soon. Customers have requested the ability to set up workflows that repeat on a regular schedule. We're preparing recurrence for time-based workflows so you can save even more time on repetitive steps, such as daily due date reminders and weekly…
-
Alerting Contacts in a cell
Hello, We have a sheet that we use as an IT ticketing sheet and Form. I setup an automation so that whenever a comment or attachment is added to a row it will notify (email) whoever the assigned technician on that ticket is. This works great when the end users comment, however, when the IT technician makes a reply or a new…
-
Request to Update: Is there a way to make some fields required
I have a form where the user is presented a form with some of the fields from the table. Once the approval routing is complete, the user is prompted to fill the remaining fields. Is there a way to make some of these fields mandatory? Currently, all of the asterisks go away.
-
Formula to combine Name and email to create a contact row
Hello, I have a very long smartsheet list of names and emails in seperate columns. I want to join them to create a new column that turns them into a contact without having to fill out the contact card for each person. I tried =Join({name}+" "+{email}) and it did join them, but did not turn into a contact. Help please!
-
Is there a way to see all recipients of an alert within the automated alert email?
I have created a Smartsheet which will sent automated alerts to multiple people. Everyone getting an alert is just seeing his/her name in 'to' but not the other names. So the person does not know who is informed as well. Is there a way to change it so that every recipient sees to whom the alert has been sent?
-
Turn Off Notifications of No Recipients
A new feature (unwanted by me) is to notify me if there are no recipients on a notification. Well, Smartsheet, you don't allow me to keep the recipients when it's a template, so whenever we use the template now we get this ridiculous notification that there aren't any recipients. Of course there aren't any recipients, you…
-
Workflow not working
Hi all, We've put a workflow together (see picture attached). The plan is as follows: a volunteer fills out online form (see attached) and selects a community group (A, B or C) to support with current flooding issues.
-
Changing the name of Sender - Emails?
Good Afternoon Smartsheet Community, How can I change the Sender name of the emails? Currently its saying "my fullname" via smartsheet automation@app.smartsheet.com" I don't want my name displayed in all the emails it's sending as I currently create reports.. so every report automation it sends it out as if I am sending it…
-
What is the time gap used to consolidate the changes made on the sheet and send a single alert email
Eg: I have a automation alert which is when a cell is changed to "Yes" for one of the column on the sheet alert me. I updated corresponding column in row 1 to "Yes" and saved the sheet. Then immediately updated the second row to "Yes" and again saved the sheet. I received one email with details of these two rows. At what…