-
Sync Automation Edits Across Multiple Sheets
I have a workspace that I use for all cross functional teams, internally and externally, for all active projects. Each active project has it's own project specific sheet. If I edit an automation on one sheet, there is no way to copy that same edit to another sheet without copying the entire sheet and starting over. Ex:…
-
Move rows automation is transferring the entire sheet, not just the rows that are "checked"
I set up the automation shown below to transfer a row to another sheet once a check mark is selected for said row. However, when the automation runs, it transfers the entire sheet to the "Past Eval Results" sheet, including the rows that are checked and not checked. Is there something I am missing in the workflow?
-
Action : change cell value
Hi Community, I feel like this is simple question, but I can make it happen. If I want to using change cell value in automation workflows, can I change the cell value by using formula? Cause I use the formula to change, the result always add ' in front of the formula…(show as the pic below) Besides, can it make the value…
-
Is there a way to generate an alert/block on Smartsheet, in case a schedule causes overallocation?
Hello everyone, On Smartsheet, I have a workspace containing a series of sheets (one for each active project) where various resources are planned. Both on Smartsheet and Resource Management, each resource has 8 hours/day available (i.e., 1 day = 8 hours). If I schedule a resource on two different sheets, assigning it to…
-
Remove "send me a copy of my responses" in Approval Requests
The email sent to users when they check the box of "send me a copy of my responses" in Approval Requests includes a link to the internal sheet which doesn't make sense and is confusing to external users who may not have access or full context to Smartsheet. I really hope Smartsheet can consider a feature enhancement to…
-
Automated project ID using 2 column variables
Hi! I'm trying to create a formula or automate the generation of a project ID but it needs to include 2 separate variables where the information are in 2 separate columns. Column 1: Has 1 of 5 pillars with the pillar number and text. Below Build a community to enable the academic mission Create a thriving, fair and diverse…
-
Dashboard PDF
Is it possible to automate sending a PDF version of the dashboard to a group or manually selecting something to send a PDF of the dashboard to a group?
-
Why i am getting one combined email when adding multiple entries in a form
Hi Friends Hope you are doing good and staying safe! I am using Automation>Trigger>Alert someone feature to get email notification when user submits the form. I want to get individual email for each entry, however if user submits the form multiple times with different data, i am getting one combined email instead of…
-
Direct Email Approval Button for Smartsheet Automation Workflows
Integrate a direct approval button within the email notification itself that allows users to approve or reject requests without the need to transition to a web browser. This button would perform the same security checks and record the same audit trails as the current browser-based approval, ensuring that the process…
-
Increased Expiry Limit for Attachments
We use the PDF generator tool to auto-generate thousands of approval letters each year. We then have an automaton set up to send the letters out the funding recipients. the validity period for the letters is 90 days, but the attachment link that Smartsheet sends expires after 30 days, meaning we get many requests from…