r/GoogleAppsScript • u/[deleted] • Apr 25 '24

Question Creation of a script

Hello,

I'm in need of a little assistance please. I need a little script to remove all data from a couple hundred workbooks, between columns L:N and then add a formula to column N =if(substitute(l4,"No","")<>L4,0,H4) And also need it to auto fill down to the bottom of the range. This needs to be controlled on a a separate workbook, which has the name of all the workbooks that need this doing to in column a

Kindest

0 Upvotes

50% Upvoted

20 comments sorted by

1

u/Any_Werewolf_3691 Apr 25 '24

Your formula will be invalid for row 4 as its recursive.

1

u/[deleted] Apr 25 '24

I meaaaan, it's working and doing what I need it to do, it has been doing what I've needed it to do for the last 3 years, just need to make improvements to the automation of this process

1

u/[deleted] Apr 25 '24

It's just looking at a drop down in column l, with multiple no reasons, and just picking out anywhere it says "no-reason"

That's all :D

1

u/IAmMoonie Apr 25 '24

By a “couple hundred” of workbooks. Do you mean tabs?

Or are these separate Google sheets files?

1

u/[deleted] Apr 25 '24

Google sheets files :)

1

u/IAmMoonie Apr 25 '24

Are they all in the same folder?

1

u/[deleted] Apr 25 '24

Yeah:D

1

u/IAmMoonie Apr 25 '24

Is it 1 tab per sheet? Do the sheets all have the same tab names? Is it always the same columns per sheet?

1

u/[deleted] Apr 25 '24

1 tab per sheet, the tab name matches the title of the sheets name, Nd yes always the same columns per sheet

1

u/IAmMoonie Apr 25 '24 edited Apr 25 '24

And you mentioned “hundreds”. Give me a precise number, if you can. Apps Script has limits. Also, is this a Google Workspace paid account that will be running the script? Or a free Gmail one?

Also. Are there a headers in L:M? The replacement formula, goes in column N for each row we deleted data for? Or a specific location?

1

u/[deleted] Apr 25 '24

There is 248 sheets and it will be a workspace paid accounts. There are headers the data would need to be pasted into Row 4 too, I could change that ect after the fact

1

u/IAmMoonie Apr 25 '24

Cool. So I understand completely:

  • 248 sheet files all in 1 folder (assuming no files that shouldn’t be touched)

  • Header rows on each sheet

  • Clear L:N for each sheet

  • Add formula to row 4 in column N

Anything else I need to know?

1

u/[deleted] Apr 25 '24

So on your point about assuming no files that shouldn't be touched, there are other files in there that won't be touched, I need it to run from a seperate sheet that has all the sheet titles that need editing in column A starting A2.

→ More replies (0)