-
Does a Slack Integration stay active when saving the original SmartSheet as a New SmartSheet
I have a Slack notification being sent for a specific row in my SmartSheet. It's a Template SmartSheet, so it gets "Saved as New" every time a new project is started. I'm noticing that the Slack notification seems to get de-activated on the new (project specific) SmartSheet I just saved/created off of the template…
-
Is there a way to copy a single field to another sheet with Data Shuttle or in another manner?
I need to copy a Key field to various sheets at certain points in the processing. We keep having errors on the sheet [running out of space] when everything is on one sheet, so we are separating out based on processing criteria. We do not want all of the row to move, as this is where are trying to save fields and keep the…
-
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?
