-
Integrating Smartsheet Reports, Power Automate and Smartsheet API
Manual task automation isn't just about saving time; it's about building a reliable, repeatable, and secure pipeline. We recently took a standard user-provisioning process that previously required 15 to 30 minutes of manual administrative effort per run and reduced it to a 1-minute automated execution. By connecting a…
-
Automatically Setting a Future Date Based on Criteria
Is there a way in Smartsheet to automatically default a date column to 30 days in the future based on certain criteria? For example, if Column A has a value but Column B is left blank, can Column B be set to automatically populate with a date 30 days from today? I tried creating an automation where the trigger is when…
-
Is there anyway to automate the process of moving an attached image to a cell?
The Smartsheet that I'm currently working on generates a document with images in it after a form is submitted. The images won't be placed onto the generated document, however, until someone manually moves the attachments to the individual cells. Is there any way to avoid doing this manually for every entry? It is similar…
-
Is it possible to create an automation that highlights only certain rows on email?
I have created an automation that sends an email when a date is reached. I would like if the email that is received ONLY shows the information in the row that the triggering date is in. Is that possible? Currently it sends the entire column.
-
Automation not triggering
Hello Community, I am having issues with an automation not firing, not sure what is tripping it up: Also I am unsure if I should see the Update Request icon highlighted in the left margin, when this fires? Of course if I manually click to send an Update Request, it does highlight, but I am trying to set this up so that it…
-
Ability to Include selected fields in Smartsheet Notifications - With out the Link to SMARTSHEET.
It would be great to have the ability to exclude link to the smartsheet while including smartsheet fields in smartsheet automated notifications. This is because we want users to use dynamic view instead of directly accessing smartsheet. With dyamic view we can control what they see and what they can edit.
-
Sent From Triggering User AND Include All Attachments on a Rows
Is there any way to create an automation that includes all attachements on a row, but also correctly shows the Triggering User? Process is User Completes Update Request with PDFS → This Triggers Update Request to Management → Management Approve via Updated Request → Trigger Email to Accounts However, the Accounts team…
-
Managing multiple due dates
Hello all, I need help creating a formula to select the most recent due date for a row. We currently have an automation that removes rows when the due date is past. Some rows have multiple due dates. We would like to enter all dates in one row, and have the sheet utilize the most current date to sort the row and then…
-
Date column auto update when changes are made
Hi, I have a sheet that lists a bunch of different sheets and workspace. On that line I have a date column when it was last updated. I was wondering, can I get that date column to auto update when a different sheet has changes made to it? Or somehow create a dashboard or report that mimics this.
-
Automation Run Options - Add Workday and monthly as an option
Problem Statement Current automation workflows run based on calendar frequency only, without considering working days. For reminder-based workflows, this creates unnecessary noise. When notifications run over weekends, users return on Monday having received multiple duplicate reminders, which leads to: Perceived spam and…