- Automation involving 2 rows
I have a sheet with a list of tasks that need to be done. Example: row1, checkbox, task name, who, start date, finish date row2, checkbox, task name, who, start date, finish date I would like to have the checkbox in row1 to trigger an alert to the who in row 2. Can someone share if this is possible and if so how should I…
- Generic email for workflow
I am building workflows for operations of various teams. I came across an issue when we implemented one of them- when the automatic workflow (Update request) goes out, the email is coming from me. I am getting questions therefore about the issue, so I'm wondering how/if I can make the 'sender' a generic account?? Do I need…
- Customize "From" sender for alerts
It looks like on April 17 Smartsheets changed the "From" address for automated alerts from "Smartsheet Automation" to the spreadsheet owner name. //www.santa-greenland.com/content-center/product-news/release-notes/personalized-sender-name-and-reply-notification-emails This has caused a lot of confusion for our team. Is…
- Workflow Approval Question
Hi everyone.. i have a pretty complex smartsheet and I'm using workflow approvals.. I have about 50 different columns, but there is conditional logic on the form - so when someone fills out the form.. sometimes they could only see lets say 5 columns (or field elements). The current automation I have is when the submitter…
- Automation notification or email not coming through
Hi! I wanted to have an automation notification set up that when "form uploaded" is checked, it notifies the person in the "manager" cell. I've tried to adjust my automation two different ways, see screenshots below. Simple enough, but it isn't going through.
- Multiple pre-built Approval Columns not available for selection in an approval workflow
I am building a process that will have up to 6 different people approving an action. I'm building separate workflows to control the trigger as some are dependent on others: 3rd, 4th, 5th will all trigger simultaneously with a field condition and a 2nd approval value of 'Approved". I keep trying to build the separate…
- Reporting on Workflow Automation
Hello, I have several sheets that have quite extension workflows set up on them. Is there any way to produce a report or print the sheet which details each of these workflows? Is this what the Workflow ID can be used for? At the moment you can sort the workflows and then go into each workflow individually to see the…
- 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…
- {{评论}}作为一个领域的自动售货机ed emails
I would like to send automated emails to certain people when a comment is added. I do NOT want the link to the master sheet to be included in that email. I would like to set up an automation that is "message only" with the {{fields}} of my choice. I need the comments fields to be included as a field in this email.
- 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…
