-
If I lock columns down so that users cannot edit them, can I still use the "Copy Row" automation
-
SmartSheet Automation - Notify Emails not triggering at all
Hi all, I've ran into an issue where on all of my sheets I have that's shared out to dozens of users and are on the distribution list to receive emails based on rows added/changed with criterias to trigger email sendouts to them. This has been working fine the past 2 years. However, as of 2 days ago all emails have stopped…
-
Multiple Conditional Pathways to One Action
Hello, I am trying to create a weekly digest to send out once a week with multiple criteria using automations/ workflows. I am running into a problem because I am having to create multiple pathways due to differing logic which is forcing me to enter different actions for each pathway. Although I know I could recreate the…
-
Automated email to Contact in a Cell
Hello, Is there a workaround to send an automated email (box check) to a contact in a cell, but its not a contact column, rather than a formula column? many thanks!
-
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…
-
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…