-
Copied Rows need update
I have 2 sheets that copy to each other, the reason being that I have one that only has some cells that I want our customer to see, the other sheet has all our information on it. The question that I have is when someone updates a row, is there some other automation that I can put into the sheet so that we will know that…
-
Automate formula based on dropdown
So I have a sheet with multiple columns. Rows automatically appear based upon a Power Automate flow from other sources and rules. It works great, but now I need to auto populate a calculated formula in one column based on a drop down selection in another. The two things I thought of don’t seem to be working. Example: I…
-
Non-Admin Viewership of Automations, Workflows, and Forms
We use a lot of sheets, forms, and automations to mages several intakes in our organization, and we have only a couple of people with Admin access to maintain all of this. When we want to make adjustments, changes, or upgrades to a sheet, we are frequently asked to find when in the form logic or automations the change…
-
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…