-
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…
-
{{A Comment}} as a field in the automated 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…
-
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…
-
Novice - Date Status Changed
I want to track when a project changes Status. I'm primarily using the Card View and want the date the Status changes or the project switches swim lanes, to have that day's date. For example: Old Status: Reviewed Date: 10/19/2020 New Status: Completed New Date: [Date Status was changed]
-
how do you reference a single cell in an external sheet...dynamically? formulas? Cell Linking?
Thank you for your time. I cant find the answer in the documentation or forum. So I am asking. a. How do I reference a single cell in an external sheet? b. Can I reference a cell by row number and column number? c. Is there a way to make this dynamic? using the ' =ExampleCell1 ' syntax is for the current sheet. How would I…
-
Random Updates - Cell History
Hi, we've been using a format where once a form is submitted, a row is copied to another "master" sheet that the team can manage off of. Recently, I've made some changes to the process (around when the copying happens), but what we're seeing is that in our Master sheet, there are random updates to cells (we have alerts set…
