nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Welcome!

Copying Alerts & Actions from sheet to sheet

Jose da Silva

Hi all,

I have a set of 5 "Alerts & Actions" that I need to set up on 32 different sheets.

Is there a way of "copy and paste" those rules, instead of manually set them up on each sheet?

Thank you.

Find more posts tagged with

Manufacturing

Sheets

Healthcare

Solution Center

Project Management

Comments

J. Craig Williams

Not through the UI.

The API does not allow CREATION of Alert Rules, but it does allow UPDATE. I have not had to test how this fully works yet, but it is on my list.

Have the 32 sheets been around 'for a while'? Sometimes in cases like this it is easier to bring over the data from the 32 sheets to 32 new versions that have the functionality (like Alerts, Conditional Formatting, Filters, and maybe others) than it is to recreate that functionality again. Seems backwards, but ... been there.

Craig

Jose da Silva

Hi,

I see what you mean.

Well, it doesn't save me as much time as I wanted, but at the end of the day it will save me some time.

Thanks for you help brainstorming this particular one.

steven.reed14881

Depending on where you are with your sheet creation, the most effective way to do this is to do a 'Save As New' from your original sheet. In the 'Save As New' dialong box, you will see a 'Notification & Sharing Options' dropdown. Make sure you check the 'Notifications and Alerts & Actions Permission Settings' box. This will replicate your Alerts & Actions to all new sheets you create.

Let me know if there are additional questions on this.

Steve

Jose da Silva

Well, I created the sheets first, then I choose which rules should I apply on them.

Now I understand that I should've done like you are saying.

Next time I know how I should do.

Thanks!

Sign in to join the conversation!

Quick Links

Trending discussions

"Fields marked with an asterisk (*) are required." line on every form.
Hi, "Fields marked with an asterisk (*) are required." is the very first line in the body of every form I create. I don't remember seeing it before (unless you missed filling out a required field; then you would see the message). Is there a way to turn it off or change it? None of my forms are in English so the message is…
Best Way to Create a Stacked Bar Chart from multiple columns
I have a sheet that I pull into a report. The report I then want to use to make a stacked bar chart and put into a dashboard if I can. The columns I am trying to make into a stacked chart are: Lead, project and phase. The issue is that there are several leads and I need the stacked bar chart to show in different colors for…
Dynamic View Issue - Group Sharing
I have a dynamic view setup for a dashboard that has NO restrictions And on the Sharing tab, I have a Group that I created as the additional share access to the view But the individuals in the Group still cannot see the data from the dashboard. Am I missing something? Because when I share the view to them individually…