-
Automatically populate "Duration" column
Hi all, I have a task tracking sheet, with each task having a start date, an end date, and a duration. I need the end date field to be populated based on the start date and the duration, so I set the dependencies and date range display accordingly on project settings. However, the duration of each task must be calculated…
-
What's the difference between Bridge and regular automations?
It seems to me that regular automations inside sheets can do most of what Bridge can do, based on the demo available, yet it's a separate product, so I can't try it myself. Can anyone tell me the difference/advantages of Bridge? Thanks!
-
How can I capture the date and time of specific column changes?
I have created a workflow that goes through three different departments. I want to capture the date and time of a request (row) coming in, and the date and time of the next action and each action after that for cycle time purposes. Currently, I can track cycle time for dates but some actions need to be carried out within…
-
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.…