-
Using sheet summary fields in an alert
Hi All, I have built a workflow where once certain conditions are met we send an alert to a few stakeholders where we give row details and reference some details stored in the sheet summary. At the moment I have not found a way to directly reference this information without adding a helper column to the row and using a…
-
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)…
-
New feature to track, monitor and manage all notifications that are being sent out via Automations
New feature to track, monitor and manage all notifications that are being sent out via Automations. Goal: To check and audit that we aren’t sending too many notifications to people, and verify that people we think are getting notified are actually being sent alerts.
-
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…
-
Generate document-Multi lines of Text issue
I am attempting to generate a document with one area using multi lines of text I put into a cell through using ALT+ENTER. However when I generate the document for these fields they do not generate vertically as mutli lines and keep scrolling as run on text. I have it set in these form fields in Adobe as Multi-Line and…
-
Make Hiding & Unhiding columns an Automation function
Perhaps my "search foo" is a bit rusty, but I could not find an existing suggestion for this specific issue, only several tangentially related suggestions. I believe this is pretty self-explanatory. I have sheets with several checkbox columns that are typically hidden, but often need to be unhidden to perform some action.…
-
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…
-
Create a new sheet from template using automation
It would be extremely useful for automation to create a new sheet using a custom template. For example, if a cell changes to a specific value, it automatically creates a sheet or sets of sheets from a custom template depending on the selection.
-
Is there a way to send out automate sending out dashboards weekly?
We use dashboards regularly for status reports, is there a way to send weekly to specific individual either as .pdf or interactive? I found this discussion and know it is on the roadmap, anyone know if it has been developed?…