-
Time zone discrepancy in Automations
Hello! Something strange has happened - my Smartsheet profile is set up for AZ time zone, and my workflows have followed that. However my Automation workflows switched to Eastern time today, so due to the time difference they all went out incorrectly. How could my Automation workflows run off a different time zone than my…
-
Has anyone seen this issue before with column references inside the message body of an alert?
The template is setup with references to columns in the sheet for notifications. After the project is provisioned through Control Center, the message body is showing {{INVALID COLUMN}} instead of the column name set in the template.. I've never seen this issue before personally. Has anyone seen it?
-
Can I use DataShuttle to consolidate data?
I have many files that are formatted the same, but contain different data. I would like to use DataShuttle to consolidate the data into a single Smartsheet spreadsheet via an Upload Workflow. I simply want the data from each uploaded file to be added to the target sheet. Is this possible? Here is the process that I am…
-
Save As New Workspace / Copy Row Automation
It would make the world of difference if when you deploy a new workspace any copy or move row automations would update to the new workspace not point to the template.
-
Document Generation - multiple templates with similar conditions
Hi, I have two templates that I want to have generated upon form submission and various other triggers in my workflow. Due to potential changes, I have it re-generate so the final "step" is the version that has the most updated information. I currently have 6 templates in a single workflow, with my condition for each being…
-
Dynamic Reporting Linking Filters
I would like to make reports dynamic so that you can link filter options to another sheet. For Control center this would be great because you can have the intake sheet (Where the data lives) drive into the report and populate the results. We would like to see it linked so if you change the data on the intake sheet, the…
-
Why isn't my email notification being sent?
I have an automated workflow set up to alert someone (several people), triggered to run once at a specific time. I need it sent to notify people to complete a form. I tested it several times when setting the sheet up by sending it to myself, but now that it's live and is supposed to go out to several people it's not…
-
Formula to look as Multi cells to check a Box on Another Sheet.
looking for help. not even sure how to Word this. but i am looking for help on writing a formula that would check a box on another sheet if this form is filled out and a assigned work order #. so if someone was to say that Step 1 is Complete with this work order #. it would Check the Step 1 box that is in the tracker…
-
Get a notification when an attachment is added
I'm trying to set up automation that will notify specific people an attachment is added to a row. I have set up automation like this but it isn't working. Please help me figure out where my automation logic is wrong.
-
Hyperlink to external site in automation message
Hi there - I'm sorry if this has already been asked - I'm having a hard time finding the answer. My goal is to include a link to an external site in my automation messages. For example, folks will come to our business and fill out an online form (through smartsheet). I then have the automations set to go to the email they…