-
Automation to change cell value based on checkbox not working
I've set up an automation to change a cell value to "Complete" when a checkbox is checked. It either changes all cell values (whether the checkbox is checked or not) OR doesn't make any change at all (when checkbox is checked). I've tried a start from scratch automation and a template. Can someone explain what I'm doing…
-
Automations
Looking to see if anyone else has experienced a similar problem or might have some insight into why the below isn't working right for the team I'm working with. We've setup a grants tracking database that will send automated alerts for various things including if an end date has passed and the grant manager hasn't updated…
-
Users Submitting From Excel to Existing Sheet
Goal: I'm looking for a way for employees to copy/paste or upload new rows of data from Excel into Smartsheet without seeing the full sheet and ideally without needing a Smartsheet account. Project Overview: I'm building an expense report system where employees submit weekly expenses for review and approval. Currently,…
-
Resource Management: Regional Public Holidays
Official Public Holidays in Resource Management are not helpful when team members work across different states or countries. The ability to define Public Holidays based on team member location (automatically would be best) is needed. The Location of each team member is defined in their profile. Use this to update the…
-
Can Form responses generate an email to an ADMIN, as well as the user?
I am familiar with the "send me a copy of my response" on a sheet's form. The format of the email the user receives is nice and looks similar to the form itself. I would like to have that same (or very similar) email sent to the Admin of the sheet as an automation. I am also familiar with automating a notification from the…
-
Did something recently change on the Smartsheet side to cause my automations to suddenly stop workin
I use Smartsheet for work and I have a set of automations that work in tandem to create a daily report for me and my colleagues. I set up these automations over a year ago and haven't touched them since. However, part 2 of the set stopped working randomly about 3 weeks ago. Part 1: Trigger: When rows are added or changed…
-
Add More Data to Generated PDFs in Later Workflows
Hello, I'd like to suggest an enhancement to the PDF automation feature. Currently, we can build PDF with cell data from the sheet, but it would be incredibly useful to allow adding of more data (or even modifications) to the PDF as part of later workflows. This could include: Appending new data collected from update or…
-
Separate reply-to email address for auto emails
Hello, I'd like to vote for the feature of a separate reply-to email address when setting up auto emails. I'm the owner of a large number of sheets, and despite it not necessarily being a problem that emails appear to come from me, i'm having a huge issue with the large number of replies i receive. Despite adding text in…
-
How to find an automation among many in a sheet
Hi, I have many (>50) automations on a sheet and I often find it difficult to find a particular automation given the paltry search and sorting functions within the Manage Automation Workflows. To recap, you can (only) filter by (All, Active, Inactive, Unable to run) or sort by (name, date created, date modified, last run).…
-
Merged: Searching for specific automations
This discussion has been merged.