Sign in to join the conversation:
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.
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
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.
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
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!
Hello, I'm working through the writing formulas optional activity and in the 'Nested IF function - Progress Column' task it directs you to put in the following formula '=IF([% Complete]@row = 0, “Empty”)'. However, when I put this formula into the spreadsheet, '04a_Marketing Request Tracker - Formulas', I get an…
I have an automation that has a condition where I am looking at the column "LEA Interco Supporting Site(s)" and trying to find columns that have the value "Fort Loramie" in them. This works well when "Fort Loramie" is the first item listed in the cell, but it doesn't work when "Fort Loramie" is the second or third value in…
Have any of you created a Smartsheet that would show the savings for a project by the month? In other words, if I saved $1200 annually and the project ended in say March, then the savings would go $120 per month, Mar 2025-Feb 2026. I have done it on Excel sheets manually, but I think there should be a way to do it with…
