-
Customization of @mention email notification Subject Line?
My team has encountered some confusion when in Outlook, unrelated email notifications generated by @mentions are threaded because they share the same subject line: "X mentioned you in the Digital Team Project Tracker sheet in Smartsheet". Is there a way to customize subject lines for comment notifications, so they include…
-
Problem with vlookup calculations
I am having a new problem with an existing Smartsheet that has worked fine until now. Existing workflows have stopped working. The problem does not appear to be workflow, but something else going on. We have a workflow that triggers off of a calculated field that is based on data in another Smartsheet. Users enter data…
-
Email import via Zapier
Hi I am auto-forwarding certain emails from Outlook to a Smartsheet list via Zapier. Everything comes across fine but certain data fields seem limited in space. The body of the email doesn't fully transfer. It seems there is a character limit to either the Zapier forward or to Smartsheet. How can I get the complete email…
-
Attachment in Alerts (without attachment as trigger)
Hi Everyone, We have an intake form which is filled by our design team with project details and drawings as attachment. Once received, we review the details and allocate a project manager (PM). We have set up an alert to be triggered to the concerned PM once he is allotted the project. We want the drawings to be sent along…
-
Emailing a row from sheets does not show who is cc'd for recipient
Hi All, Something has changed recently in this process, it used to be that if I sent a row to Andy, Bob & Dan - everyone would be cc'd on the email received & when anyone responds, everyone gets a copy - and a group conversation occurs. Now, when we send a row to Andy, Bob & Dan, the recipient does not see that anyone else…
-
Automation - Alerts for External Users
Hi there, I am having trouble with the automation in Smartsheet, specifically around alerting external users. The automation is for an issue control sheet, with automation that if "status" = resolved, alert user who logged (via form) with custom message. The automation works soundly, and when I test it with an internal…
-
Using Automation to send single sheet email request, rather than multiple emails
Currently my automation is used to update my users once weekly to update any of their rows with the a cell marked 'Open'. This sends anyone with 8+ cells a single email spreadsheet of the applicable rows that they can review and then update as needed. To everyone else this is spamming six emails to update each row…
-
Form Notification - Email Address
Hi, I have created a Smartsheet's form with an automated process behind it that sends approval requests based on certain criteria. Is there a way to change the naming on the email that people receive so instead of people receiving it as Name via Smartsheet <automation@app.smartsheet.com> the name could differ. I would…
-
SmartSheet Alert Mail Sender
Hi all, I am the owner of 10 sheets each of one is used by different users. I have set up alerts automation but when the email is sent, it is always shown my email address instead of that of the user. This is a problem as the email is sent to external customers who are always receiving email from me and not from the…
-
Project/Sheet Name in subject of Alerts/Request/Reminder
Hi everyone, I have a team managing several projects (80+) at a time. I have setup alerts, reminders etc for each project. So the same people will get alerts for different projects. How do I incorporate the project name (which is the sheet name) in the subject of those alerts so it is easy for the team member to know for…
