-
Automagician Badge - how to earn it?
I had tried to submit my input on why I'd like to earn this badge but the site stalled and I can't find the place to do so, again. So here's my input: In our initial sheet I created back in December 2010, we have 55 workflows active that saves me-and other coworkers-a vast amount of time each day. The automated…
-
Create copy of Smartsheet data, scheduled and automated to be used as trendlines
I have created a PowerBI dashboard using smartsheets as the data source. Live updates are working perfectly, and updating data is running smoothly. I have been asked to show a trend line, and progress with these metrics. How can I build a table (or Smartsheet) using snapshot data in an automated workflow using smartsheet?
-
Populate Notification Message Header with Information from a Form Contact (email/name)
Is there a way in the automation workflow to have the notification header auto-populate the name/email of the person that has submitted a form? I have a form where individuals have to enter their name and email. When we want to go back to our emails and search for the proof of submission notification, it's generic, and…
-
Data Mesh multiple target sheets - Cell Max Limit Error
Hello all, hoping to get some input here or curious if anyone has had experience with this. Currently have a datamesh set up looking at Report (Source Sheet), that sends about 28 columns to 1 Data Processing sheet (target sheet) based off of a UID. This target sheet hits it cell limit a couple times a year and we have to…
-
Is it possible to export/download the automated workflows on a sheet?
I have about 30 automated workflows on a sheet and I'd like to download/export those so I can review them as well as have a copy should something ever need to be changed. Is this possible? If not, can it be submitted as an enhancement request?
-
Merged: Workflow to Send Attachments without link to Sheet
This discussion has been merged.
-
Is there a way to make a workflow send the contents of a comment to a contact in a cell?
Hello, My team uses smartsheet to track requests that come in via a form. We then use the comments section to log updates or closure information when it's time to close the request. Do you know if there is a way that I can create an automation that will send the comment contents to a contact in a cell? If this isn't…
-
Is there a way to lock a singular cell in a row with automation?
Hello, My team uses Smartsheet to track requests to our team via a form. I was wondering if there was a way to use a workflow that, after a certain amount of time, it would lock a field on that row so that it can't be edited again? Is this something that's possible, or wait for a later update that includes this?
-
Enable Workflow Automation Repetitions
Hello Smartsheet community. I have created a workflow automation that will email a custom message to the contact(s) in a specified cell. This workflow must initially trigger when: There is a change in a cell, in this case "Lifecycle Status" When two days have elapsed since the cell change. If the notified user does not…
-
Total Time Spent On Various Sites
Hi I have a sheet that tracks time spent on multiple sites, I'm trying to add this to a metric sheet but struggling to get the metric sheet to add the total time spent against each site as a total. Can anyone help with the formula for this? Thanks