-
How Can I Set Up Hourly Archiving Without Breaking Datamesh?
Hi there, I need help setting up an hourly automation for our Department Calendar sheet. Here’s the situation: This sheet is connected to the Master Events sheet via Datamesh. When an entry is cancelled, Datamesh needs to trigger on the master sheet before the entry is archived from this sheet. If the entry is archived…
-
Adding a secondary sheet into the equation
HI! I have the below formula which is pulling info from a sheet and giving me a percentage based on the p/f in a column. I have a third sheet that is the same info as the p/f sheet this is based on (technically the archive of this one) that i would like to add in as included in the percentage. So basically my formula needs…
-
Request an Update weekly automation only worked once and I can't figure out why
I have an automated workflow set up to run weekly and request an update when the project is in certain statuses. The automation only ran once and now it's not working even though I have it set up to run weekly. I need help troubleshooting why this isn't working.
-
Automation - Improved "Change Cell Value" Action based on Cell Type
The "Change Cell Value" action when doing automation leaves a lot to be desired. Currently it seems to only be able to affect Text/Number, Dropdown, and Checkbox columns. There is a separate action to fill out a date for Date cells, but that is also very restrictive in that it only can enter the date of when the automation…
-
Automation Workflow Data
We have quite a few automation workflows running on multiple workspaces/sheets, and I was wondering if there was a way to export all these different jobs into some type of data format (spreadsheet) ? I am trying to build a user guide on our processes, a lot of our employees do not know what Smartsheets is doing, so I…
-
Has the "When rows are changed" trigger changed?
Hi Smartsheet experts, I'm building a workflow with a segment that should trigger when there is a change on ANY of the column fields. For some reason the Trigger will not leave it open ended. What could be happening?
-
Zapier Connection to the Smartsheet Eu Servers
I want to connect Zapier with my smartsheet account to run some automations an online lead generation bot to be exact Zapier support team has given the following info: Currently it is not possible to connect to the smartsheet.eu with Zapier the limitation is imposed based on compliance with Smartsheet; we cannot confirm…
-
Slack and Smartsheet Update requests
I've looked on the community site and web resources, but I can't seem to find anything that directly shows how you create a project update request and completion directly in Slack. I can send update requests to Slack as a reminder through automation, but I don't see how you send a request for update and actually complete…
-
Introducing Query Streams - Automatic Database to Smartsheet Sync
Hi Smartsheet Community!We're Query Streams, and we built a tool to automatically keep your Smartsheet updated with data from your databases and APIs. What it does: Connect your database or API to Smartsheet and set a schedule. Your sheets stay updated automatically - no more manual exports or copy-pasting. New records get…
-
WORKAROUND FOR AUTOMATION EMAIL TO RECEIVE SEPARATELY AND NOT BUNDLED IN ONE E
Hi anyone here have a work around or formula in my case i created a project where in Effectivity date reach it sends email notifications i also created a helper column for subject to have a unique fields and not bundled in one email but in this case if the same effectivity date different details it was placed in one email…