-
Automation in Template not Working
I have a template that has an automation that moves rows at a certain time of day to another sheet. When certain users create a sheet using the template the automation is unable to run. with the error "unknown destination". I need some help. Do all users need access to the destination sheet as well? I want to avoid that.
-
Conditional Text
Hello! I am trying to figure out if I can do a sort of conditional text entry. For example, if I enter "St. Bernard" in a cell in column A, then the cell in same row of column B would auto-fill with the word "dog" but If I were to enter "Maine Coon" in a cell in column A, then the cell in Column B would auto-fill with the…
-
Conditionally send reports
Problem: Sometimes my reports have no items as all the actions are closed in the underlying sheet. It is then irritating for my email recipients to receive a blank report. Ideal state: To have two options: Dont send the report if blank or send an automated email still on the recurring schedule stating a custom message…
-
How to send automated daily digest email of updates
I'm trying to set up an automation to send a daily digest email of updates to users linked to an item in Smartsheet. I have a smartsheet where each row is an event. When any cell in that row changes, I want the users involved to have some notification of the change. My current automation is triggered "when rows are…
-
Email Attachment Automation not working
I have a workflow setup that sends an email notification to someone when a new row and an attachment are added and includes the attachment for download. This hasn't worked since 9:45am yesterday morning, did something change? Test emails are going through but not including the attachment even though there is one.
-
Automate Copy/Paste Special in same sheet or to another
We have "live" metrics collecting data from multiple departmental sheets, and display them on a dashboard. Works beautifully. The challenge is, we need to save each metric into an historical sheet, which means we need to store the numbers as static numbers. Copy/Paste Special accomplishes this — but it has to be done…
-
How can I copy a row from sheet with cell links to antoher sheet? Reccuring workflow not working
Hi all, I am trying to COPY rows automatically when a project owner name is changed from the original sheet to a destination sheet. The original sheet has cross links to another sheet and hence, I tried to use recurring workflows. Neverthless, not able to find the desitination sheet in the search box. I have tried to write…
-
Date format in automated emails
Hi there, I've set up an automation on a sheet and noticed that the dates in the automated emails are in the incorrect format, despite me setting my regional preference in the settings. I have the dates set up in my settings for Brazilian format (i.e. DD/MM/YY) and this is how it shows in the Smartsheet itself. However, I…
-
Automation from dropdown list
Hi all, I’m building workflow automation for tour requests. When a requestor selects items from a dropdown list, the responsible people should be notified. Attached is a picture of my automation. Only the first item (Metal) triggers notifications, but not the second or third (Tissue & Anatomical). Any suggestions on how to…
-
Smartsheet Automation received and submitted by user, but not appearing in sheet
Hi there, I'm hoping you can help with an issue I'm having with a sheet. I created an expenses sheet. Once the expense is submitted, via form, to the sheet, I can check a box, click save, and it sends an automation request to a budget manager to approve or decline the expense. This is in the form of a check box. The user…