-
Automated notifications from wrong sheet
Hello, has anyone experienced workflow notifications being sent from a different sheet? We received several today- The linked sheet was correct, however all the information was from a different sheet.
-
Automated Email when rows are added or changed - email not sending properly
Hi, I have a workflow setup to email anyone in the Assigned To column when a row is added or changed on a sheet. We duplicate these sheets each month and add new rows with new assigned to contacts for each row. The issues is that not all assigned to contacts are receiving the email through the workflow. The workaround…
-
How do you reference "any/all cells within a column" within an if/then formula?
I am using two sheets to validate against each other. Sheet A is my main sheet. I have all the data I need related to my project there. Sheet B has a list of places we cannot work with. I want to say that If a cell in sheet A is equal to anything in any of the cells within sheet B (which is only one column) then I want it…
-
Template Workspace / Copy Row Automation
I am using Control Center to deploy projects. Inside the template are workflows that copy rows to another sheet inside the same template. When a new project is made I have to go edit all copy row workflows as they continue to point at the template and not point to the new sheets in the new project. Am I doing something…
-
alert with specific row
How can I set up to send an alert for specific row when it matched a condition . I tested it and it triggers correctly but always send the first row. for example, it should send out the 10/10/2022 row only, but it sends out 10/2/2022 row any idea? Thank you
-
Broken Workflow Report
Is there a way to run a report (or an easy search) which lists which projects (over 300 of them) have a broken workflow, rather than checking each one individually to see if the automations are broken?
-
If Statement to Change Drop Down List Value
Hi all! This is more of a clarification to another question than anything else. I have a column of drop down lists ranging from 0%-100%. With that being said, the default value is blank, if would like to make a column long formula that does the following; if the current cell is blank, set value to 0%, else do nothing. I…
-
Can Document Builder work on .docx files instead of .pdfs?
My team would like to have documents autogenerated in Smartsheet with .docx filess specifically mapped to the Smartsheet. I've only been able to do this with PDF's, is it possible for .docx word files?
-
Auto Reminders
Hello, We are setting up a workflow in smartsheet that once submitted via form, will flow from one approver to the next. There is no standard as for when the entries will be submitted. I need to set up a reminder for each approver so after 48 hours, if they have not approved, they receive a reminder that an action is…
-
Template Set: Marketing Request Management - Standards - Scope of Work cells
I am following the initial setup steps for the Marketing Request Management template set. In Step 2.C. customize the sheets for your project types and team, when I change the cells in the Standards - Scope of Work sheet, it breaks the communication to the Intake Sheet and Form, and gives me an error message "Incorrect…
