-
Columns clogging downstream sheets
Does anyone know of a way to limit columns moving from one sheet to the next sheet when leveraging Move Rows automation? I'm finding downstream sheets are getting clogged with unused columns and numerous blank cells. This creates confusion when training new employees, but also creates additional workload for managers who…
-
The scope of "Update" for automation via API?
I know that new automation rules can't be created through the API but the API doc says that they can be updated. Does anyone know what exactly can be updated in the automation through the API. I would want to take an existing Copy Row rule and change 1 condition and the path to the destination sheet. Thanks!
-
Enable Workflow Automation Repetitions
Hello Smartsheet community. I have created a workflow automation that will email a custom message to the contact(s) in a specified cell. This workflow must initially trigger when: There is a change in a cell, in this case "Lifecycle Status" When two days have elapsed since the cell change. If the notified user does not…
-
Enable PDF print of Dashboard and Export to Excel of Reports from Power Automate
It appears that the automatic (scheduled) backup feature from Smartsheet does not include either the Reports or the Dashboards. These are left to the user to be manually "Save as" or "Print as PDF" every single time one wishes to have a backup. This is very inconvenient, I have about a dozen dashboards that I would like to…
-
Using Data Fields to Automate New Forms
Hello everyone! I am building a data tracker sheet that will track event data sourced from a form that goes out to event coordinators. I'm trying to figure out a way to push them a 'new form' to fill out when they select that they have multiple events they need to submit. Ideally, I would like to automate this process…
-
Can you automate sending an attachment when a form is submitted?
Once a user completes a form, I'd like to automate sending a follow up message with an attachment for them to complete. Is it possible to add an attachment via the automated message or through an automation? I don't see a way to attach/ add a hyperlink. Thanks!
-
Help with a NETDAYS formula
I have a formula in my sheet that is counting the days of an assignment since it was assigned. I would like it to stop counting once the row is marked complete or a date of completion is added. For example, in the screenshot below, the 37 in row 4 should be a 36 since the "Date Completed" column is filled in and/or the…
-
Automate Trigger Slack DM's based on assignee email addresses in Smartsheet
It would be phenomenal if we could trigger messages to DM's or Ephemereal messages from Slackbot or the Smartsheet Slack App using some connection between the user's email in Smartsheet and the same email in Slack. This would allow users to be notified individually of changes or needs without having to alert the whole…
-
Indenting Rows automatically
I have the following data in a sheet. I want to create a report (or anything that makes sense), that says if it is anything other than "Top Level", it will be tabbed over under the parent process it aligns to. Parent Process "1 - Process Details Test" aligns with Process Identifier 1. I am hoping to have this automated.…
-
Automation works correctly when manually changed in sheet but not when input through form
Hello, I created an intake form for a project request. In the form there's a field where the submitter has to select from a dropdown list of Contract Information choices. Here are the automation logic I have: When I tested it by selecting the different options in the dropdown in the sheet column, this works correctly.…