-
Is it possible to set up a recurring update request that keeps sending until all cells are updated
Hello, I've set up a sustainability tracker for a team at my organisation and they are hoping to limit who access to it, whilst still wanting input from certain collaborators. My idea to achieve this would be using an automated workflow - namely an update request. I'm wondering if it is possible to set up the update…
-
"Change Cell" Automation Not Working
I have created an Automation that auto-assigns a technician based on names in another cell within the same sheet and it is not changing my cell values: The Trigger is set for when a row is added (rows are typically added in bulk as a copy paste from an Excel File) The "Audit Assigned to" Field is a single-select dropdown
-
Workflow to Automate Document Generation?
What's the simplest process for using "Document Generation" when a new "Form" is submitted? Does anyone have a workflow that can automate this process without the need for a "Gatekeeper" or someone manually generating the row-level document after the form is submitted? Example - We have a PDF form that requires a signature…
-
Error Creating Charts Without Info in Template
I created a few charts in my template but because there is no information in the sheets (because it's a template) the charts show an error. Wouldn't typically be a concern because as soon as the template is used the information will be populated and the chart wouldn't error out. However, when I use this template in control…
-
Alerts but send populated Fields only
The form I use to gather data is made up of circa 150 columns, and different columns are populated each time a form is filled out, depending on options selected in the form (logic). When I set up an alert, I just want it to send populated fields so they don't have to scroll through a big list of empty fields to see…
-
Any way to have a formula automatically change input when a set of new rows added?
Hi, trying to automate a process whereby the change from week to week on a project is reflected in a graphic on a dashboard. Right now, I have the source sheet for the data copy the rows to a separate sheet once a week. I want a formula to simply find the difference between last update and the new one. This is what will be…
-
How do I set an automation to trigger 3 days before a date in a column?
I have a column in a sheet called Install Date. I need to send out an automated message 3 days before the install date. Am I on the right track doing it this way? I think the first portion is what's throwing me off and my only options say that the trigger is for a date in the past or I have to set a specific date.
-
Alerting when a new line is added to a report
Hi folks! We have our product roadmap that is being accumulated from 200+ different smartsheet for the different product development teams. My job is to build a technical support training curriculum for the new features that are being deployed so we can better serve our customers. I created a report that accumulated all…
-
Syncing cells across sheets.
I have a process where I have multiple users entering data into their own individual sheets. I want copy from those multiple sheets into a single master sheet. I also want to update the master sheet cells any time a cell is updated from the individual sheets. I have been able to get this working, but the linking process is…
-
Populating Entire Columns Referencing Another Sheet
Hi all! Over the last week or so I have been trying to build a report that shows average tasks completed over a given 12 week period. So far I have been successful in creating the formulas for these, which have been working on dummy data. Now I would like to process live data from another sheet. Well ideally I would…