-
Merged: Move Rows to TOP of another sheet
This discussion has been merged.
-
How to make alert notifications vertically formatted?
I don't want the alert style notifications to send horizontally with a bunch of squished and elongated columns (seen below) I want it to show vertically with up/down scroll:
-
Denial Reasons and workflow
HI all. looking for thoughts on how to provide reason codes when a form submittal goes through the approval workflow but then is declined and providing a denial reason as part of that denial so the submitter can see that in the email response. Thank you
-
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…