-
How do I combine an approval workflow and update fields into a single email request?
I have an approval workflow that sends an email to a user but in that approval I would like the user to complete a couple fields of data. Instead of forcing that there is two separate emails (one for approval and one for field updates) can this be combined into one interaction with the user?
-
Bundle together rows under 7 and use placeholders in workflow automation update request
We have a scenario where Sponsors are asked to provide short updates on all of the projects, they have responsibility for. The notification they receive includes placeholders to show the project name. The feedback on this is that they would like to receive one email showing all the projects they are responsible for and the…
-
Inclusion of options missing in the Move/Copy workflows
Hi When we select a sheet row and move/copy it to another one, we're presented with the "Include Attachments" and "Include Comments" options. On the other hand, moving/copying rows through automation workflows does not provide these options; and this is what I'd request Smartsheet team to include in the workflows as well!…
-
Automation/Workflow Example/Tests
Although it's typical to need to run a few tests for a workflow or automation, it would be great if we had the option of previewing what the automated emails/notifications/alerts would look like for individual users with different types of permissions. A view "View As" type of feature.
-
Hiding Or Removing Duplicates In a Report
Hi all! I have a report on a sheet that has many duplicate values, and for the sake of nice presentation I would like them hidden. To further explain my situation, I have a sheet I am referencing that has tasks, days to complete, the week of completion of these tasks, and finally the avg days to complete a task per week.…
-
Looks & format of automated emails
Hello, I would like to use automated emails & reminders for client-facing communication. But the amount of irrelevant information enclosed is a problem. Are there currently solutions to any of these? 1- Unnecessary header that has a Log In button next to it which confuses external contacts who do "NOT" need to get into the…
-
Trigger a monthly approval automation?
Hi there, A team keep track of hours worked per project on a sheet that looks like this. I'd like to trigger a workflow that sends the project manager an approval request on the first date of each month to approve the work completed the month prior. However, I do not want the project manager to get separate emails for each…
-
Formula to add leading zero to months 1-9 of the year only.
I need to add leading zeros to month numbers Jan-Sept only as sorting by month number does not work due to Months Oct-Dec starting with number 1. If I sort by month number, it comes up like this. 1 (Jan), 10 (Oct), 11 (Nov), 12 (Dec), 2 (Feb), 3(March) ... Does anyone have a formula for this?
-
Alert for a particular change value
Question: when creating an alert inside a workflow, is it possible to include exactly which column change?
-
Organize Automated workflows
For sheets that have a ton of workflows (50+) it would be nice if we could organize the workflows in more ways than currently offered. I have to scroll for quite a while to see all of the workflows and it is easy to miss the one you're looking for. Could there be another way to view, single lines with pertinent info?