-
Is it possible to automate a work flow that sorts rows by date when a sheet changes?
I have a sheet that I pull reports from into a dashboard. it would be great if the most recent rows sat at the top of the sheet. Currently I have to manually sort the date column.
-
The ability to omit blank fields in email notifications
When sending alerts and requests through automation, we currently have the option to send a message including either all fields, specific fields or the message only. For my particular organisation(and i would imagine many others), none of these options work. We have dynamic forms that build themselves based on answers and…
-
Automation - While copying/Moving Source Sheet to Target Sheet, how to update columns in Target shee
I have following questions related to workflow automation Is it possible, based on certain conditions in Sheet-A copy Sheet-A to Sheet-B and manipulate another column in Sheet-B (This Column is not in Sheet-A) through a function? Based on certain conditions in Sheet-A, will it be possible to delete a row in Sheet-B?
-
Document Generator Quit Working
My document generator on 2 of my sheets just stopped inputting the data into the PDF forms. It will name the file correctly using one of the data fields but won't put the data in the file anymore. I remade my form and the automation like 10 times! The file is small, sticker size 2.25 x 1 and has a barcode font on it. This…
-
INDEX(COLLECT()) function to pull partial data
I'm using an INDEX(COLLECT()) function to pull data from cross sheet reference; however, is there a way to pull partial data from the reference cell? For example, the reference cell is "Molecular Division" but I only want to pull "Molecular" into the target cell.
-
🍂Harvest🍂 New Insights in our Upcoming Live Virtual Workshops – Available in Global Timezones!
Join one of our live, interactive workshops for expert insights and real-world applications that will ☕ pumpkin spice☕ up your Smartsheet skills and demonstrate how Smartsheet can relieve the common pain-points in your workday! You’ll leave 🥧stuffed🥧 with knowledge that will help you spend less time on repetitive tasks and…
-
Data Shuttle inconsistencies in updates
Hello, everyone. We've been working with support but I wanted to get a feel on what other users are finding. Does anyone else find inconsistencies in their Data Shuttle updates? It's been suggested to us that we need to try smaller batches that what we're needing but even with that we're finding that things like mapping…
-
Filters for Multi-Select Drop Down Column
I have a column in my sheet that allows multi-select in a drop down. I want to create a filter that will show me all the rows that have multiple values selected in that column, how can I create a filter for that?
-
Approval Request - link expatriation
Hi, I'm in the process of setting up a system for gathering approvals and I'm curious to know if the approval link included in the automated email has a set expiration date or if approvers have the flexibility to access the link at any time to cast their vote.
-
Including Images in a Workflow Automation
Hello Everyone! I am creating an automation and am aware that an image cannot be included in the body of an automation email. However, I opted to have the image attached to the workflow email by including certain cells. The issue I'm running into is that when the image is attached to the email I am getting the following…
