-
Is there a way to automatically extract the activity log?
I have an extraction of the activity log every week and I was wondering if there is a way for an automatic extraction of this log
-
Run a formula on a destination sheet when rows are moved to it
I'm migrating a manual process we have into Smartsheet, and keep finding new hills to climb! : ) Essentially the process will result in document generation (PDF) after different team members submit info onto a sheet using Forms. First, I found a formula solution that worked for me to combine all sheet data (from columns)…
-
google drive integration storage best practices
We are an enterprise higher ed group familiar with Smartsheet, but new to using the Google Drive integration. We are (hopefully) transitioning our documentation processes away from clunky word docs into the more automated Google Docs direct from our project register as work requests come through. I've gone through the…
-
Autopopulating a job number
I have set up a sheet that will house our jobs. It has been requested that each job have its own row, nestled under the customer's name. Our job numbers are derived by using the customer number, year, and job number for the year. For instance, the first job of 2024 for Customer A with a customer number of 1000 would have a…
-
Proofs disappearing in some rows when transferred to another sheet
We have automation set up where when a task has been marked complete, it moves to another smartsheet for complete tasks. This helps keep our open tasks smartsheet uncluttered. I just noticed that some of our rows that have moved sheets have lost their all of their proofs. Based on complete dates, it looks like the issue…
-
Request an Update: Un-editable Text Box
Hi everyone, Looking for a little help with an issue that keeps occurring on multiple sheets. I am creating an 'update request' trigger, to send to contacts in my sheet to update several text box cells within a row. I am including several specific text box fields for them to update in my customized message. When my contact…
-
Automation Not Working
Hello, I'm at a loss. I've created several automation rules in the past and I cannot figure out why this is not working for me. I have a simple sheet with the following columns: Status (single select dropdown) Sub-Category (text) Task (text) Assignee (single contact column) The automation rule is triggered when the…
-
Change Task Categories of other Cards when One Card is Updated
We have a lane that contains several services to be confirmed when a new client uses our product. There are multiple cards in that lane that need to move to other lanes based on the updating of the task category of one. For example, If a client says that they are going to use Product A, then we move it to a lane for our…
-
Multiple Step Automations
Hi All, I have a form that collects data. Once the form is submitted, it changes a field to "In for Approval". I then have multiple automations set-up to assign 7 different Owner based on certain criteria and 1 to send a request for approval to the newly assigned Owner. Most of the time this seems to be working correctly,…
-
big ideas for document generator
My team has 10-20 projects running at any given time in varying scale both in size and end user comfort with Smartsheet. We are (hopefully) transitioning our documentation processes away from clunky word docs into the more automated Google Docs direct from our project register as work requests come through. My first hope,…