Known issues – add-ons for Google Sheets

Below you can find a list of possible issues that can occur when working with Google Sheets add-ons. They are caused by current technical limitations on Google's end. We are looking for ways to go around them, though in some cases the only thing we can do is wait for bug fixes or new possibilities for third-party developers. We appreciate your patience and understanding.

If the problem you are having is not described here, please use the contact form at the bottom of the page to write to us or email straight to support@ablebits.com

Report a new issue

Installation issues

The only option in the add-on menu is Help

Sometimes when you're trying to run the add-on, the only option you can see in the drop-down menu is Help. This is usually caused by Google internal problems.

Current solution: Reload the spreadsheet a few times and see if other options appear. If this doesn't help, email us to support@ablebits.com

Issue-prone add-ons: All Google Sheets add-ons.

drive.google.com refused to connect

This problem is caused by an issue on the side of Google when you are logged in under more than one account.

Current solution: Sign out of all accounts and log back in only under the account you used to grant permissions to the add-on. If this doesn't help, email us to support@ablebits.com

Issue-prone add-ons: All Google Sheets add-ons.

The add-on doesn't install at the first attempt

This is a known Google problem that affects all add-ons in Google Workspace Marketplace. You click Install, allow permissions, see the spinning arrows working, then they disappear but the page still says Install. There's no confirmation of the successfull installation whatsoever.

Current solution: Since we can't control the problem, we have to ask you to try and install the add-on a few more times.

Before you do so, make sure to sign out and log back into only one Google account — it often helps.

Also, please try to install from both the Extensions > Add-ons > Get add-ons menu in your spreadsheet and from a Google Workspace Marketplace page in a new browser tab.

If the installation still doesn't go through, please report the problem to Google — this will help them in debugging. Just click the icon with a question mark at the upper-right corner of the installation page/window and select Send Feedback:
Send feedback in Google Workspace Marketplace.

Issue-prone add-ons: All Google Sheets add-ons.

I removed the add-on but it's still in the list of my tools

First, check if you share you spreadsheet with someone. If so, the Extensions menu will show all add-ons used by all users in this document. It's just the way spreadsheets work. Even if you make a copy of this shared spreadsheet, its settings will inherit all add-ons used in the original document. Hence, you'll see the option to install the tools.

If you don't share the spreadsheet with anyone, contact your Admin to make sure the add-on is not installed on your entire domain. If it is, please ask your Admin to remove the tool for you or simply change its settings.

If the add-on is not installed to the entire domain (and you're not in a shared spreadsheet), or if you make a copy of the shared file, just click that Install button to get the add-on back and then uninstall it from your account the standard way.

If this doesn't help, email us to support@ablebits.com

Issue-prone add-ons: All Google Sheets add-ons.

Common issues related to data processing

The add-on doesn't work (the Next button is disabled, "working" arrows are spinning all the time, or there is no result)

This issue occurs if you are logged in under more than one Google account. It happens due to an issue with multiple Google accounts on Google side.

Possible solution: Please sign out and log back in with an account under which you want to work with your spreadsheet.

Issue-prone add-ons: All Google Sheets add-ons.

Custom functions don't work — #NAME, Loading..., etc.

Some add-ons return the result as a formula. In this case, they use custom functions that we created for Google Sheets. The performance of any custom function fully depends on the work of Google Sheets which is beyond our control. There may be troubles to load all custom functions and we're unable to change this.

We've already reported this behavior in the Google internal bug tracker system and will continue investigating the issue and searching for ways to influence it.

Possible solution: Set the locale in File > Settings. If you're not the spreadsheet owner, ask the owner to refresh formulas for you using the tool. If this doesn't help, please try to clear cache in your browser, sign out and back into your Google account, or even make a copy of the problem spreadsheet. The formulas may load eventually.

Issue-prone add-ons: Function by Color, Combine Sheets, Consolidate Sheets, Power Tools.

API call to sheets.spreadsheets.values.update failed with error: Unable to parse range

When the add-ons are trying to update the info on the sheets with a plus sign (+) in their names, they stop with an error saying API call to sheets.spreadsheets.values.update failed with error: Unable to parse range.

The issue is new and first occurred in April, 2023 after Google Sheets updates. We reported it in their internal bug-tracking system, so please star it as well to let them know how many people are affected.

Current solution: Remove the plus signs (+) from the names of the sheets that you're about to process with the add-ons.

Issue-prone add-ons: All Google Sheets add-ons.

The add-on cannot paste the formula: limit for 50k chars in a cell

When you insert the result as a formula with some tools, the length of the formula depends on the number of sheets/files you refer to. In some cases (mainly with Combine Sheets and Consolidate Sheets), the formula may exceed the maximum of 50,000 characters in a single cell. To our regret, Google Sheets prevents such long inputs into cells.

Current solution: Process data by parts.

Issue-prone add-ons: Combine Sheets, Consolidate Sheets, Function by Color, Multiple VLOOKUP Matches, Power Tools, IF Formula Builder.

IMPORTRANGE — internal error

When you combine data from multiple sheets into one, the IMPORTRANGE function used for this purpose may return an internal error. Since this function is standard for Google Sheets and we simply utilize it for our add-on, we cannot control or affect it.

The bug has already been reported to Google. But, unfortunately, they can't fix it since too many different circumstances cause it. So here are the found temporary workarounds.

Possible solution: Change the case of a letter used in the range (the second argument), like this:

IMPORTRANGE("id", "A:A") > IMPORTRANGE("id", "A:a")

If the above solution doesn't help, duplicate your IMPORTRANGE inside IFERROR, where the first IMPORTRANGE is your original one, while the second features a letter of another case. For example:

IFERROR(IMPORTRANGE("id", "A:A"), IMPORTRANGE("id", "A:a"))

Do this for each IMPORTRANGE from your formula.

Get help from the Google support team: Open a new Google Workspace Support Case where your particular problem can be analyzed by a support specialist.

Issue-prone add-ons: Combine Sheets, Consolidate Sheets, Power Tools.

All records starting with a single quote (') are processed without it

Due to the Google Sheets peculiarities regarding data formats, our add-ons cannot detect a single quote at the beginning of cells, e.g. '+12

Hence, values in such cells are processed without the single quote. This may result in unexpected cell content if you use single quotes at the beginning of calculations, etc.

Issue-prone add-ons: All Google Sheets add-ons.

Custom functions are not updated automatically

Caused by a known bug in Google Sheets, unless you change a value in one of the cells, we can't automatically update the formulas we insert.

Current solution: Function by Color introduced the Refresh option to update all custom formulas it inserts into your sheet in one go.

Issue-prone add-ons: Function by Color, Power Tools.

Scenarios don't appear in the Extensions menu

When you place the results into a new spreadsheet, you won't see your saved scenarios in that file under the Extensions drop-down.

Current solution: Run the add-on once in that new spreadsheet and all your scenarios will appear in the Google Sheets menu.

Issue-prone add-ons: Remove Duplicates, Merge Sheets, Power Tools.

Dates cannot be processed

When the add-ons process dates, they don't get them in the same way you see them. When the add-on script gets an array of data to process, it receives the date as a combination of numeric characters that differ from the date format displayed to you in the sheet, e.g. the script sees "Mon May 05 2014 00:00:00 GMT" instead of "5/5/2014". This is the reason why neither search nor replacement will return correct results. And that's why many of our add-ons do not process dates — to avoid data corruption.

Issue-prone add-ons: Advanced Find and Replace, Merge Values, Modify tools in Power Tools.

The add-on gives a Server error

This is a very general error. It may be caused by exceeding the limit of 10 million cells in Google Sheets. If you have a large spreadsheet, you can check this by trying to duplicate the sheet with your data, you will see the error right away.

Current solution: Avoid the options that add cells and skip the option to create a backup copy of the sheet.

Issue-prone add-ons: All Google Sheets add-ons.

The add-on returns no results

When you work with a large range of various data and if you have a very slow Internet connection, the add-on may hit Google's 360-second time limit for operation. Our developers work hard to avoid such issues, please let us know if you encounter it with any Ablebits tools.

Issue-prone add-ons: Advanced Find and Replace, Table Styles.

Specific issues with some add-ons

The Clear tool doesn't remove comments

When you run the option Clear all, it removes everything but comments from cells since Google Spreadsheet Service doesn't allow to access and manage comments at the moment.

Issue-prone add-ons: Power Tools.

Function by Color cannot process large data sets (over 200K cells) with one formula

Due to some Google Sheets limits for custom functions, our Function by Color tool cannot process large data sets (over 200K cells) with one formula.

Current solution: Process your data in smaller parts with a few Function by Color formulas. You can sum up their results afterwards if needed.

Issue-prone add-ons: Function by Color, Power Tools.

Function by Color freezes when trying to refresh results for numerous formulas. Some valuesByColor formulas disappear

Due to Google limitations for custom functions, in order to recalculate formulas there has to be some change made in the values. Instead, our Function by Color temporarily deletes its own formulas and inserts them back triggering the recalculation. Once the process is over, all formulas are back and updated.

Nevertheless, in rare cases with too many formulas, the add-on freezes unable to return all results.

Current solution: Restore your data through File > Version history > See version history and process data in smaller parts.

Issue-prone add-ons: Function by Color, Power Tools.

Function by Color doesn't support Theme colors

Though theme colors were introduced to Google Sheets a few years back, their algorithm still doesn't allow our add-on to get all colors in the selected range.

Current solution: Use standard Fill colors rather than Theme colors.

Issue-prone add-ons: Function by Color, Power Tools.

Multiple VLOOKUP Matches returns incorrect results

When looking for matches in a column with both dates and time, the add-on pulls incorrect/not all matches.

Current solution: Apply the same number format to the entire column with your records: Format > Number > Date time in the Google Sheets menu.

Otherwise, with values formatted differently within the column, for instance, pure dates (9/27/2019) and date and time (9/27/2019 9:00 AM), the add-on won't be able to process data correctly.

Issue-prone add-ons: Multiple VLOOKUP Matches, Power Tools.

Sheets Manager copies/moves a Chart sheet incorrectly

When Sheets Manager copies/moves a Chart sheet (a sheet without cells, with a Chart separated from its source data), you may sometimes see that the Chart looks different or it is empty whatsoever. This happens due to the Google Sheets limitations and affects Charts without the data in the X-axis.

Issue-prone add-ons: Sheets Manager, Power Tools.

Responses

I have installed sheets manager but I'm unable to use it as it shows the option only Help, the start option is not visible "Extensions>Sheets Manager > Help"

I m using google workspace for business, we are small resort and we use the google sheet for our daily room reservation. every now and then there is an error of doc comment limit, made a new copy, it worked for few month initially and now even new copy does not resolve the problem.

Sagar Mutha says:
April 11, 2024 at 5:47 am

If there are multiple entries in the main sheet that match entries in the lookup sheet, only one entry in the main sheet is matched and the rest are considered as Non-matching.

Trying to refresh results. Add on wants me to sign in so I select the email in which the document is saved under but I'm not signed in; it just doesn't do anything. So I try my main email and it says I'm signed into too many google accounts (2) and the add on won't work if I ignore that message. How do I get it to refresh the results?!

Getting error message Unknown function: 'valuesByColor'.

I have refreshed the results - Nothing
Went in and redid the formulas and the color name changed - It used to be the color number ("#f3f3f3") now it has the color name (light gray 3) and is still not working.

Please let me know what I need to do - Thanks - CP

My data validation for check boxes doesn't seem to be working correctly since I installed this add on. The check boxes are there (false) but when I click it to check the box, instead of it being a checked box, it changes to "TRUE" and then the cell gives me this error message: Invalid: This cell's contents violate its validation rule. The only way to fix it at the moment is to insert the checkbox again (which changes it back to unchecked/false) and then click it again.

Why is this happening?

Hello Maggie,

We appreciate your feedback. Our add-ons do not interfere with your checkbox settings. Please make sure you have the correct settings in Data > Data validation.
If that does not solve the problem, please help us troubleshoot the issue by sending the following information to support@ablebits.com:
- The name of the add-on that you are using.
- A screenshot showing the problem.
- A screenshot of Data validation settings.
- The same screenshots with the add-on uninstalled.

We will assist you as soon as possible.

ANDY Turbyfill says:
December 26, 2023 at 3:51 pm

I have been using the Power Tools, Function by Color on previous Sheets. I made a copy of the present sheet I am using so I could start a new 2024 year. Everything copied correctly. Unfortunately now all of my Function by Color commands are not calculating. I keep getting a "#NAME?" error. I have even tried to create a new Function by Color and it is not working for that either.
The ERROR keeps displaying - Unknown Function: 'valuesByColor'
I do have the PowerTools tool bar running on the side of the page.
Any help would be appreciated.

We're sorry, a server error occurred. Please try to re-start the add-on.
set values statusColumn

I am only trying to remove duplicates from about 10000 rows. Was working fine and then suddenly this is happening.

Peter Johnson says:
November 28, 2023 at 4:34 pm

Having a issue with the find and replace. Won't let you search notes in sheet 1 have closed and logged back in but still same issue

I used the Multiple Vlookup Matches tool today. It would not work when I chose Paste Formula- I get an error. But if I paste result, it works.
This means I need to come back every day that the source data sheet is updated and perform a new Vlookup match, instead of automating it with the formula.
How can I resolve this?

the side bar won't load, this happens about every 6 months and I forgot what i did to fix it last time

Hello,

When trying to use the formula to combine sheets the following message is returned: "Unknown function: 'CONSIDER_HEADERS_CS'."

Can you please advise on how to solve this issue?
Thanks

Hello Samia,

Thank you for your comment.

As the Combine Sheets tool uses a custom function to process your data, you need to start the add-on in the newly created spreadsheet with the result so that the formula starts working. Please have a look at the limitations of standard functions used in the Combine Sheets formula (particularly, point 4.1).

If you have any questions or need further assistance, please email us at support@ablebits.com.

the extension is not working automatically example: before when I inserted another color in the spreadsheet it updated and counted this new color, now it only counts this new color when I press the refresh button.

Hello Lucas,

Thank you for your comment. Sorry, our add-on has always worked this way. You see, by default, in Google Sheets changes of the background color are not considered as a reason to update formula results. Unfortunately, we can't control or bypass that.

We have described the possible ways to update results on the tool's help page.

I am using the Merge Sheets function and I am noticing that it appears to be creating tables in the sheet where the data is being consolidated where I can see the line where the table ends and the data below or to the right of these lines is not being updated. Is this an issue with the program or am I doing something wrong?

Rifky Andrian Prasetya says:
April 5, 2023 at 1:07 am

duplicate +1st occurrences doesnt work properly, there's no data duplicate but the color turn red, wich is sould be inform me that this data is duplicate. Please fix this as soon as possible, or tell me whats wrong? I need this add-on for my work.

Hello Rifky,

Thank you for your comment. Sorry to hear that you've faced difficulties of this kind.
For us to be able to help you better, please email us at support@ablebits.com with the screenshots of your source data, the result you are getting and screenshots of each step of the add-on showing the options you select.
We'll do our best to fix the problem.

Hamza Amireh says:
March 28, 2023 at 4:21 pm

hi, first thank you, second i'm trying to extract urls with powertools, the extract works fine on small number of rows but not 700 rows or more, as it try to extract and then it fails and says an error, is it because of memory limitation, is there a way to increase the capacity of the operations or i just have to work in chunks?

After installing, the Tools are available under Extensions. The tool to extract hyperlink addresses worked one time but the next time I went to use Power Tools any tool I selected sent me to Install, but that 400 errored out.

Hello,

Thank you for reporting the problem. Please note that there is currently an issue on the side of Google that occurs when you are logged in under more than one account. I kindly ask you to sign out and log back in only under the account you used to grant permissions to the add-on and try to reproduce the issue.

If the issue persist, please send a screenshot of the error message you get to support@ablebits.com. Thank you.

I'm trying to compare two columns of two different sheets, to find duplicates, with the free version it worked, now that I've paid, it finds the elements to color but in fact the cells are not colored

Brian Loffer says:
March 6, 2023 at 9:39 pm

Features are not activating. This is being replicated on another user's computer and account.

Example:
Click on "Merge and Combine" menu option and see the typical available tools (merge values, merge sheets, combine duplicate rows, combine sheets, consolidate sheets.). However, when you try to activate any of those tools, nothing happens.

Hello Brian,

Thank you for reporting the problem. Please note that there is currently an issue on the side of Google that occurs when you are logged in under more than one account. I kindly ask you to sign out and log back in only under the account you used to grant permissions to the add-on and try to reproduce the issue.

If the problem persists, please email us at support@ablebits.com with a screenshot that illustrates the issue or, even better, create a short video showing it. We'll do our best to help.

I'm getting an error message saying "The add-on couldn't paste data undefined" says:
March 2, 2023 at 6:26 am

This only happens on one spreadsheet.

Hello and thank you for reporting this problem to us.

This issue is related to various strange symbols that occur in spreadsheets after import. We have already reported it to Google in their bug tracking system. Please open the issue as well and click the star icon to the left of its name so Google know that more people are affected:
https://issuetracker.google.com/issues/250852483

In the meantime, if you share your spreadsheet with us (support@apps4gs.com), we will help you find and remove those symbols. Or you can do that yourself. To start, please download the MS-mask file:
https://support.ablebits.com/MS_mask.rar

The mask in that file will search for those symbols (it's in the file since the text is not supported by emails):
1 Open the standard Find and replace tool (Ctrl+H).
2 Paste the copied mask to the Find field.
3 Make sure the Search is set to the main sheet and the checkbox called Search using regular expressions is ticked off.
4 You can choose to replace these symbols with a space or delete them completely (simply don't enter anything in the Replace with field).

Please let us know about the result.

The app does not open when clicking extension> remove duplicates

I have spreadsheets with a "barcode" field, that is a text-formatted number. The reason it is text-formatted number is because barcodes sometimes start with "0" and number-formatted fields will drop this automatically.

Today, when using Merge Sheets tool, upon completion of the merge all barcodes lost their leading 0 characters.

The barcode column was not being used as a lookup field and there was no data being merged into it.

I have used Merge Sheets many times in the past and not encountered this issue. It seems to be a very recently emerged bug.

Kind regards,

Shane

Hello Shane,

Thank you for reporting this issue.

If your column with the barcodes is located in the lookup table and you are trying to add it to the master table during the merge, please make sure that there is no quotation mark (') before the barcodes with the leading 0 and the following format is applied to the first row with the data: Format > Number > Plain text. Then try to merge the sheets once again.

If the column with the barcodes is located in the master table, please check that there is no quotation mark (') before the barcodes with the leading 0.

If the problem persists, please share an editable copy of your spreadsheet with us (support@apps4gs.com) with a description of your task. If you have confidential information there, you can replace it with some irrelevant data, just keep the format.

Note. We keep that Google account for file sharing only and don't monitor its Inbox. Please do not email there. Once you share the file, just confirm by sending an email to support@ablebits.com.

Feel free to contact us back if any further assistance is needed.

i've paid via paypal. bank deducted my money and i havent been updated about the renewal. its still havent been renewed

Veronica Mock says:
January 25, 2023 at 6:16 pm

#NAME? - valuesbycolor unknown function error received.

I have checked local - all good. Function works in other sheets, just not this one. It's a duplicate google sheet - does that make a difference?

Thank you

Hello Veronica,

Thank you for your comment.

There could be an issue with the permissions. Could you specify if you are the owner of this spreadsheet? If not, the owner of the spreadsheet needs to have Power Tools or Function by Color installed, please let them try to start the add-on and click Refresh results if this is the case.

If you still have difficulties, please reach out to support@ablebits.com for further assistance.

Installed FBC, menü is there, inserts formulas fine, but GSheets keep returnig "NAME?" and "unknown function" for any of FBCs functions.

Hello Vassili,

A lack of locale in the spreadsheet may prevent the function from calculating the results as it doesn't know what delimiter should be used. Please go to File > Spreadsheet settings and see if you have a locale selected there.
If not, please set one and confirm your action, then select the Refresh results under the Function by color in Power Tools. The function should work correctly then.

Tasha Peters says:
January 6, 2023 at 7:55 pm

I'm working on compare columns or sheets and on step 4 of 5, it will not let me move to the next step to complete.

Hello Tasha,

This may happen if no columns are selected for comparison. If the headers in your table are empty or if they differ, please pick the couples of columns to compare manually: select the main column and click on Select Column under Table 2 columns. The add-on will compare values in these columns.

Please also check out this online help page for the Compare Columns or Sheets tool.

If the recommendation above doesn't work, please send us a screenshot of what you see on step 4 of the add-on at support@ablebits.com. We'll look into the issue.

Hi,

Today I'm trying to use the merge sheet function, but I keep getting zero results. I know there should be at least 135 matching cells that should be updated.

Hello,

I am trying to use Mail Merge for Gmail by digital inspiration. I purchased the license that says there is a 24 limit of 1,500 emails.

I have only sent 400 and it cut me off saying I'm at the limit. Why is this?

Jared Spaulding says:
December 13, 2022 at 12:15 pm

Hi, been using the merge tool for close to the length of the free trial period.

The most common error I am running into is once the cells have been merged, I can't grab and move the box to a new cell.

Ex. the merge tool does its thing and deposits all the data into one cell. Then I want to move that cell with the data in it, usually to a cell to the right. So, I click on the data filled cell and it highlights, then positioning the cursor over the border of the cell it turns into a hand and typically I can then just drag that cell's contents and reposition them. After 10-12 merges, typically I am then not allowed to do it, which means I have to use a cut and paste function.

Not the hugest of deals for my project, but thought i would pass it on.

I am moving, at most 100 characters from one cell to another. I am running google sheets on Safari (15.6.1), on a MacBook Pro

cheers

I am having this issue: "The add-on doesn't work (the Next button is disabled, "working" arrows are spinning all the time, or there is no result)"

When doing merge sheets on step 3. I have signed in to only one account and tried incognito. Still no luck.

Please advise. Thank you.

ELISA ZARONI CAMARGO says:
December 8, 2022 at 7:37 pm

Did not work.
Only Help available after install.
I do not want to search your FAQ for the first step.

Kjartan huseklepp says:
November 29, 2022 at 8:52 pm

I bought this to make a lot of relative formulas absolute, BUT it doesnt work when the formula contains infinite columns. This =INDEX('Øvelsesbank'!$AK$6:$208;;MATCH($Z19;'Øvelsesbank'!$AK$3:$3;0)) becomes this: =INDEX('Øvelsesbank'!$AK$6:$$208;;MATCH($Z$19;'Øvelsesbank'!$AK$3:$$3;0))

That means that i cant use it as of now

Hello Kjartan,

Thank you for your comment.

We have been able to reproduce the issue you described and our developers will fix it in the next version of the add-on.

In the meantime, please use the standard ranges in your formulas, e.g. $AK$3:$AZ$3 instead of $AK$3:$3.

Sorry for the inconvenience caused.

Marc Solterbeck says:
November 27, 2022 at 10:08 pm

Hello dear people,
I just installed your add on merge sheets and I think it works great.

Do you have a tip for me how I can run my saved scenario automatically.
Or also via a button that I can integrate into my Google Sheets?

I would be very happy about a short answer.

Warm greetings
Marc

I get an error while merging files
"The add-on couldn't paste data
undefined"

the time zone is the same in both files. merge options - fill in the missing ones and add the new ones at the end of the table

When I try to go into Power tools the only options are go back(recommended) and Advance. However both are disabled and will not allow you to press them. No actions can be taken. Please advise.

Hello Andrea,

Sorry you are having issues with the add-on. Please note that there is currently an issue on the side of Google that occurs when you are logged in under more than one account. I kindly ask you to sign out and log back in only under the account you used to grant permissions to the add-on and try to reproduce the issue.

If the problem persists, please send the screenshot of the problem to support@ablebits.com. We will do our best to help.

Alexander Petrov says:
July 7, 2022 at 10:19 am

I have purchased a subscription for 12 months last night, received a code and when I put it in the activation field it says "Subscription has expired". Can you please check what's going on and get back to me. I've emailed you on your support email with proof photos/invoice, etc.

I have this issue. Please advise

n-dxjj3j53hrmaob3uuovq3ylcie5a3rpav2upfka-0lu-script.googleusercontent.com’s server IP address could not be found.

Hello HUY MAI,

Thank you for your comment. It looks like there's a problem with your Internet connection.

Please try to clear the cache in your browser (here are the steps for all browsers) and restart your router.

Your proxy filter can also block the connection. Make sure to whitelist the following URLs:
docs.google.com
aapgate.ablebits.com
cdn.apps4gs.com
googleusercontent.com

If none of this helps, please contact your Internet provider.

Sorry we can't assist you more.

Ismael Bengco says:
June 8, 2022 at 4:56 pm

Whenever I click START, the menu won't appear and error states that drive.google.com refused to connect.

Hi there,

We have installed this add-on on our computer and we wanted to try it before subscribing. The issue is that it stopped working after 2-3 days. Everytime we try to use it, we have 2 scenarios:

1. It keeps asking to install it (even if installed) and if you click on install, it loads forever.
2. We are able to open it, but an error screen appears saying "Failed connection to google.drive.com"

Can you please advise? The add-on was really useful for our daily tasks and we wanted to use it and subscribe.

Thanks,
Martina

Michael J Peddicord says:
April 6, 2022 at 7:07 pm

https://imgur.com/a/Qr5X8kT

I'm using it to merge localization sheets, so I can make sure the changes look good from the translators.

However, some of our text strings start with a +, which is something a google sheet assumes is a formula of some kind. But the source document and the lookup sheet have every cell set to plain text. Yet the final documents shows these strings as formula errors.

There doesn't seem to be an easy way to fix them either, selecting all and selecting plain text doesn't correct them.

I'd like to hear if you have a quick way to fix these for me. Or if you could add a checkbox during setup to treat everything as text only, or some way to fix this. There are 250 fields that looks like this and editing each to add an ' at the beginning isn't really sustainable.

Thanks very much.

Hello Michael,

Thank you for your comment. Sorry to hear that you are having difficulties of this kind.

Unfortunately, we can't reproduce the same content of a cell with + as you have. We always have = instead of + in the cell.

For us to understand the problem better, we’ve sent you an email requesting some additional information. Please email us back with the requested details at support@ablebits.com. Thank you.

Hazwany binti Jamaluddin says:
April 6, 2022 at 3:07 am

There is no start option after installing add-on extension called Power Tools

Bill Palmer says:
April 1, 2022 at 10:41 pm

Merge Sheets add on fails on startup.
Says "Understanding your data" and "Merge Sheets Startup" but gets no farther than that.

Hello Bill,

Thank you for reporting the problem. First, please note that there is currently an issue on the side of Google Sheets that occurs when you are logged in under more than one account. I kindly ask you to sign out and log back in only under the account you used to grant permissions to the add-on.
If this doesn't help, please try to clear the cache in your browser. You can find instructions for all browsers here: https://www.refreshyourcache.com/en/home/

In case the problem persists, please send the screenshots of the errors you get to support@ablebits.com.

Sheets manager cannot detect some folders within one of my folders. Please help!

Hello Won Suh,

Thank you for your comment.

If you are trying to copy or move sheets to another file using our Sheets Manager, please specify what option exactly you choose, how you search for the necessary spreadsheet, what the add-on shows you, and what exactly is located in your folder(s). Any screenshots or a short video illustrating the problem would help a lot. Feel free to email all the details to support@ablebits.com.

We'll look into this issue. Thank you.

I run the remove duplicates function to look for duplicates and ignore first instances. I then want it to delet all duplicates. It is finding duplicates and says they are being removed but they are not being deleted.

If I run the add-on again immediately afterwards it returns the same duplicate count and still doesn't delete the duplicate rows.

Just downloaded the Split add-on but it's not letting me select which column to split it from

please advise

Jeremiah Masopust says:
March 16, 2022 at 6:25 pm

I have purchased a year subscription to Abel Bits however I keep getting a pop-up that asks me if I want to buy the year subscription or the lifetime subscription. This is utterly aggravating because I already gave you my money, so please stop soliciting me the exact same product i already bought last week.

Shashi Vardhan Yasa says:
March 7, 2022 at 7:04 am

When I installed the extension called power tools and when I am trying to open it it displays empty page without any features like blank page it is showing.

Hello Shashi,

Thank you for contacting us. Please note that there is currently an issue on the side of Google that occurs when you are logged in under more than one account. I kindly ask you to sign out and log back in only under the account you used to grant permissions to the add-on and try to reproduce the issue.

If you still see a blank screen when you start the add-on, please specify what browser and its extensions you have. Try disabling the browser extensions and starting the add-on again.

In case it doesn't help, please send me your browser name and its version number to support@ablebits.com.

Suddenly all of the cells with a function got stuck on loading. I tried deleting the function and reinserting it, but the process to set up a function is now incredibly slow, and again, it gets stuck on loading, even with just one running. I tried uninstalling and reinstalling the app and got the same problem.

Hello Chloe,

I'm really sorry you've encountered this difficulty with our product.

I'm afraid it's a widespread issue that we're unable to bypass right now. You see, valuesByColor is a custom function that we created for Google Sheets. But its performance depends on the work of Google Sheets which is beyond our control.

We've found a similar problem (Custom functions failing) mentioned in their internal bug tracker system (https://issuetracker.google.com/issues/36763283) and have already reported that it's back. We'll continue investigating the issue and searching for ways to influence it. I will also add this info to this page shortly.
We would greatly appreciate if you could also open the issue and star it and maybe even comment to draw Google team attention to the problem faster.

You can also copy only the following part from the formula: =valuesByColor("lime", "black", A4:A61), and paste it into an empty column in the same file. Then send us the screenshot of what it returns. It will help our dev team dig deeper and report the problem to Google correctly.

The good news is that all formulas successfully load over a short period of time. Please try to clear cache in your browser, sign out and back in to your Google account, or even make a copy of the problem spreadsheet. The formulas will load eventually.

We sincerely apologize for any inconvenience that may be caused to you by this.

Some friends and I are making a guest list for an event and updating the list using function by colors. At first, the cellcolor() formula was working, as we are reaching two hundred people, the code just started saying "Array arguments to COUNTIFS are of different size." despite it working and not being changed the function only sometimes calculate the formula and new functions don't work on the sheet

Hello Sammy.

Thank you for your comment. If you get the 'Array arguments to COUNTIFS are of different size.' error, the problem is in the COUNTIFS Google function itself, and not in the Ablebits add-on. Please make sure the ranges in your formula refer to the same amount of data. For example, =COUNTIFS(A2:A200,"Yes",C2:C100,"No") would be incorrect, =COUNTIFS(A2:A200,"Yes",C2:C200,"No") is the correct one.

In case you use our valuesByColor and get the result 'loading', please have a look at this issue:
https://www.ablebits.com/docs/google-sheets-add-ons-known-issues/#loading-formula

When I click on merge sheet. It continues to show drive.google.com refused to connect. When I try opening merge sheets in another account that doesnt have the extension, it doesnt give me that error code. Just asks me to purchase. So I am not sure why its showing up on my paid version but fine on the non paid version.

Julia Harrigan says:
February 21, 2022 at 10:22 pm

I am trying to combine ~30 sheets of data with about 100 rows of data each. I keep getting a message that they were combined successfully but when I check my results only the first two sheets combined

Hi, I'm trying to use merge, with the results:
The add-on couldn't paste data
API call to sheets.spreadsheets.values.update failed with error: Invalid values[1][1]: struct_value { }

What seems to be the problem?

Nothing works. Whatever I click, nothing happens.

When I move multiple sheets to a new or existing spreadsheet (say "Name1, Name2, Name3")the order gets reversed ("Name3, Name2, Name1") and it is annoying and time consuming to again put them in correct order. Can this be adressed please

Hello Aman,

Thank you for your feedback.

We are aware of the issue you reported and our team are already working on the fix now. It will be available in the next version of the add-on. I cannot give you the exact timing, but we can let you know as soon as the update is released.

Our sincere apologies for any inconvenience.

this is an FYI Table Styles breakthrough (temporarily) I got it to work for 1 day.

I have two google profiles work (A) and personal (B) and use table styles for sheets with both.
I tried this yesterday and it worked although, temporarily.

1). opened a new chrome window under my work account
2.) shared the sheet to my personal account
3). opened sheet in personal account
4). connected to drive.google.com under work account
5). reloaded my cookies (CTRL+SHIFT+R)
6. opened same google sheet with work account
7). selected a range and opened table styles
8). applied a style it worked
9). I could then open any google sheet and the extension worked. (no sharing necessary)

Today I skipped the file-sharing (numbers 2 & 3) but performed all other steps, assuming there was some kind of cookie reloading that worked. it did not.
then tried the other direction (from personal to work) same result.

This is just an FYI. I just wanted to provide my input of this use case in hopes that it helps you define a solution or workaround. I use this product often and the only way i can do it now is to either copy the data to my personal sheet, apply a style or share it to my personal account and apply the style from there.

Alvin Brinson says:
December 7, 2021 at 4:07 pm

Merge duplicate rows does not preserve position of cell background color. Highlighted rows in the source data are not moved properly, leading to rows highlighted in the result that never were highlighted, and originally highlighted rows no longer so.

Hello Alvin,

Thank you for your comment.

For us to understand the problem better and be able to reproduce it on our side, please specify what options you choose on each step of the Combine Duplicate Rows add-on and send us a few screenshots displaying your source data, the result you get after combining the data with our add-on, and the result you'd like to get. You can email all the details to support@ablebits.com.

We'll look into this issue. Thank you.

Garrett Laidler says:
November 30, 2021 at 8:22 am

Getting error that Google is refusing to connect.

Hello Garrett,

Sorry to hear that you are having difficulties in accessing the add-on.

Please note that there is currently an issue on the side of Google that occurs when you are logged in under more than one account. Please sign out and log back in only under the account you used to grant permissions to the add-on and see if the issue persists.

If the above recommendation doesn't help, then please email us at support@ablebits.com for further assistance.

When using the comparison tool, it is simply not loading to even move forward in the comparison. Can someone please take a look?

Hello Michael,

Thank you for your comment. Sorry to hear that you are having difficulties with our add-on.

Please note that there is currently an issue on the side of Google that occurs when you are logged in under more than one account. I kindly ask you to sign out and log back in only under the account you used to grant permissions to the add-on and try to reproduce the issue.

If the problem persists, then please specify what tool for comparison you've used exactly and email any screenshots illustrating the issue to support@ablebits.com.

We'll try to help you further. Thank you.

Hi there!

When I try to merge sheets, at the end of the process, it says:

The add-on couldn't paste data
Invalid argument: timeZone. Should be of type: String

How can I solve it? Thank you in advance!

Hi Sergio,

Thank you for your comment. I am really sorry that you have encountered a problem using our add-on.

Please go to File > Spreadsheet settings, manually change the time zone to any other from the list and back to your original time zone, and then press Save settings. Then try to run the add-on again.

If you still have any difficulties, please email us at support@ablebits.com for further assistance.

Shweta Tiwari says:
October 29, 2021 at 4:43 am

Hi my power tool refused to connect. What to do?

Kew Chien Chong says:
October 8, 2021 at 9:42 am

Hi I was using the find and delete the duplicate in rows.

trying to [delete the whole selection rows.]
Been using it for awhile and it works fine all the time. but it doesn't work correctly after update.

30k+ rows of data will be messed up as some cells/row will remain there, seems like it only delete the selected rows/cells, not the entire rows from the sheets.

Patrick Claflin says:
October 1, 2021 at 9:56 pm

The following formula causes incorrect results to be displayed if the color specified is not in the specified cell range.
It should be "0" it shows "1"

=SUM(COUNTA(valuesByColor("light yellow 2", "", E3:Q38)), COUNTBLANK(valuesByColor("light yellow 2", "", E3:Q38)))

Hello Patrick,

We haven't provided a way to create one formula with more than one color by the add-on, COUNTA and COUNTBLANK in your case. You need to enter one formula for each color you want to count. Afterwards, you may combine all formulas using the SUM function or just sum up the results for each color (i.e. if you have results by color in cells D12 and E12, then enter =SUM(D12, E12) in a different cell to get the result you need.)

We will consider embedding this possibility in one of the future versions of the add-on. Please let us know if you have any other questions.

I have tried and tried. I cannot remove this addon. It keeps coming back up telling me my free trial has expired.
Ive been through every sheet on my drive, removed it from the sheet and uninstalled it. 6 weeks later it comes back and starts that popup again.

How do I remove this permanently?

Trying to use Combine Sheets in Google Sheets. Power Tools loads. Navigate to Merge & Combine okay. Click on Combine Sheets. Working arrows spin. App doesn't load. HELP.

it automatically appears on the right side of screen every time I open gg sheet and it make the gg sheet become sluggish a little bit and a white bar "no result" show up on the upper-left corner of screen and block other gg sheet functions

I added the feature to sum by color yet it keeps returning a sum of zero no matter what I do

Hello Matthew,

Thank you for your message. In case you have already selected a locale and it didn't help, please confirm if you are the owner of the spreadsheet. If not, the owner of the spreadsheet needs to have Power Tools or Function by Color installed, please let them try to start the add-on and click Refresh results if this is the case. I would appreciate it if you update me about the result by sending an email to support@ablebits.com.

I cannot open and run powertools. I've cleared my cache, cookies, and data. I've uninstalled the app, restarted my CPU, closed out of google sheets, and reopened and I still cannot access this tool.

Please help!

Hello Jack,

This is a follow-up to let you know that the servers are up and running and the add-on should work fine now. Please try it on your data and let us know if you're still having any difficulties accessing/using the tool.

I sincerely apologize for any inconvenience that may be caused to you by this.

Paul Stephens says:
July 22, 2021 at 1:27 pm

Hi

When using the split function to split data into several sheets the add on is adding a trailing space to the new sheet name. Could this be changed to not add the extra space or is there a workaround/quick way of editing?

thanks

Hi Paul,

Thank you for contacting us and for your question.

Please note that the names of new sheets are formed on values in a key column(s) you select to split by. So we recommend checking if there are no extra leading spaces in the cells of the selected column(s) before splitting. Our Remove spaces and delimiters tool can help you quickly cope with this task. Once you eliminate all extra spaces in the key column(s), please try to run the Split Sheet tool again.

If you still have any difficulties, please do not hesitate to email us at support@ablebits.com for further assistance.

Fitri Hidayati says:
July 19, 2021 at 1:01 pm

Dear Admin,

I've design 1 sheet report to summarize all other sheet with template, line, etc. so when I use your code, I just run and it's done.

Your new update change it all. After I run your code, the lines and other setting setting disappeared and I have to make the setting again.

Please fix them.

Thank you.

Hello Fitri,

Thank you for the comment. If you use Combine Sheets and choose the Use a formula to combine sheets option, please remember that Google Sheets functions do not support formatting - such is the standard behavior. In case you use another tool, please specify which one and send us the screenshots of your data before and after the add-on's work along with the options you choose to support@ablebits.com. We will do our best to help.

ERROR - Unknown function: 'valuesByColor'.

Cell says #NAME?

Hello Nathan,

Thank you for contacting us.

Sorry to hear you are having issues with our add-on. In case you have already selected a locale and it didn't help, please confirm if you are the owner of the spreadsheet. If not, the owner of the spreadsheet needs to have Power Tools or Function by Color installed, please let them try to start the add-on and click Refresh results if this is the case. I kindly ask you to update us about the result by sending an email to support@ablebits.com. Thank you in advance.

Brittany Hopkins says:
April 16, 2021 at 10:59 pm

Unable to combine multiple sheets due to the number of rows exceeding allowable amount. Each sheet that is being adding has data in at most 30 rows. I am combining 150 sheets so this should not create an issue.

It is saying that there are more than 50000 characters in the cells, this does not make sense to me. Please assist as soon as possible. I paid for the subscription believing I would be able to utilize it today.

Eric Hampton says:
April 15, 2021 at 4:20 pm

When I run the compare columns or sheets script and choose the move function when going through the process, it has started creating multiple duplicate sheets instead of the one duplicate sheet.

Hello Eric,

Thank you for your comment.

Probably, you have the "Create a backup copy of the sheet" option checked on step 1 of the Compare columns or sheets wizard. In this case you will get two additional sheets after the add-in processes your data: 1 - a new sheet with the duplicates or uniques you have chosen to move; 2 - a backup copy of your main sheet with the original data.

If it is not your case, then please email to support@ablebits.com for further assistance.

during combining it doesn't copy the comment/notes associated with the cell.

Hello Pradeep,

I'm happy to let you know that the feature has been implemented. The updated version of Combine Sheets pulls notes associated with cells to the result. As for the comments, it's currently technically impossible to pull them as well. We'll be happy if you share your feedback on the update!

BROOK C WILSON says:
March 20, 2021 at 5:48 pm

Doesn't do anything but color the target box. Does not process my selected range values in any way. Tried various values for the arguments in the "Function by Color" sidebar and found it does nothing except color the target (paste results to) box. Uninstalling.

Hello BROOK,

I'm sorry to hear you decided to uninstall the add-on. Since we didn't get any support requests from you, I would like to offer our tech assistance. If you give me some details about the problems you are experiencing, we will try our best to make our add-on work for you. Any screenshots illustrating the problem would help a lot. Feel free to send them to support@ablebits.com.

Kazi Ataul Kabir says:
February 20, 2021 at 4:57 am

HI
I just want to uninstall Power Tools permanently but I removed it many times but it's still showing in the Google sheet add-on. Even I removed from Account apps. Can you help me to solve this problem, please?

I am getting a "drive.google.com refused to connect" error when trying to start Power Tools. I can't refresh, I've checked settings, everything seems to be working.

Charles Smith says:
January 29, 2021 at 2:43 pm

The skip empty cell function isn't working. I have checked the box but when I merge the values, it adds a comma for any empty cell. I tried different combinations of parameters but I couldn't get any of them to merge the cells and skip the empty ones.

I am trying to shuffle cells with hyperlinks. Upon shuffling, the links are no longer present in the cells. Is there a workaround for this?

Hello Barbie,

Sorry to hear you are having such a problem.
Please note that there is currently an issue on the side of Google that occurs when you are logged in under more than one account. I kindly ask you to sign out and log back in only under the account you used to grant permissions to the add-on and try to reproduce the issue. In case it persists, please let us know at support@ablebits.com.

Stephen Pierpoint says:
December 29, 2020 at 5:40 pm

When Starting Name Split, it opens up asking to select the column name but a pop up to buy another subscription comes up and I cant close it to split the names.
I try to click the Split button quickly however still doesn't work.

Hi, the add-on "Merge Values" is blank. I can't work without it.

Hello Shiera,

Thank you for contacting us. Please note that there is currently an issue on the side of Google that occurs when you are logged in under more than one account. I kindly ask you to sign out and log back in only under the account you used to grant permissions to the add-on and try to reproduce the issue.

If you still see a blank screen when you start the add-on, could you please specify what browser and its extensions you have? Please try disabling the browser extensions and starting the add-on again.

If the issue is different, please describe it in more detail. We'll do our best to assist you.

I am combining sheets using the formula and for some reason when it combines them only in one column it will have numbers come through but if the cell contains a letter in that column it wont show anything for that cell

Hello Toby,

Thank you for your comment. When you combine sheets using our add-on and choose to have the result as a formula, the add-on uses the standard Google Sheets IMPORTRANGE and QUERY functions in the resulting formula. If there are mixed data types (e.g. numbers and text) within a column, the QUERY function returns only the majority data type leaving the rest as empty cells. You can read about other limitations here.

If it is not your case, then please email us (support@ablebits.com) a few screenshots displaying the data you are combining and the result you are getting. We'll look into the issue and help you further.

Thank you so much Katerina this helps me understand better what is going on! Has there ever been a good work around for this issue like adding in some argument to say to bring in all the data instead of just majority?

After starting shows a crashed screen and Gets a message "unable to connect drive".

Hey team,

We have an issue,
We've bought a lifetime subscription. And now it doesn't allow us the options of finding duplicates . We would like to know the reason why .

Thank you

the function merge duplicate rows are not working in my spreadsheet knowing that my spreadsheet is not exceeding the mentioned maximum numbers of cells and not even close to that number, this is the statement of the error that comes to me whenever I used the mentioned function ( ERROR: Диапазон не найден )
Note: it comes with a language that I don't understand

please help me with this problem ASAP

regards

Hello Ahmad,

Thank you for your message. This problem occurs when you select entire columns rather than a specific range. Please try to select your entire table the following way: select any cell in the rightmost column of your table and click the Auto select button. The range should look like this: A1:D100, for example.

Then please proceed with the steps. If the problem persists, please email us at support@ablebits.com.

Hi ,
Did my renewal nearly 3 weeks ago and i haven't received new licence key , no response email as well , can i get help here .Thanks

Hi Ken,

Thank you for contacting us again. I'm really sorry you didn't receive our responses, thought we replied to your email a couple of times. When it comes to renewals, the activation key remains the same. It has just been resent to you from the Ablebits support team. If you don’t see it in your Inbox, please check your Spam/Junk/Trash email folders. Thank you.

Scott Raffensparger says:
June 15, 2020 at 5:43 pm

Google sheet problem?
> Add-ons will no install/Uninstall correctly on shared sheets.
> Many of the things already mentioned.

Compare two sheets:
I have two sheets "Year 2020" and "Year 2021" is a copy of "Year 2020", The data expected to be different. The formulas should match. I made formula changes in "Year 2020" I would like to copy the changes to "Year 2021".

> how do I compare cell formulas? this may be a google sheets limitation.
> setup for a cell to cell comparison is difficult. if I can select all columns in table one, I need to set up table 2 columns to match table 1.

Kourosh Parsapour says:
June 11, 2020 at 9:12 pm

Hi. I've paid for and received my lifetime activation key on 4/21/20 but was deployed soon after in order to provide support as a physician during the COVID-19 pandemic. I've recently returned and wanted to install the activation key but I'm unable to see or find the field for entering my key code. Please help.
Thanks in advance for your time in this matter.
Dr P

Jordan Bober says:
May 27, 2020 at 7:15 pm

Hi, I have a license for Merge Sheets, but "Save Scenarios" doesn't seem to work for me, and the options to run scenarios don't show up in the add-on menu either. Do I need to do something to enable these features?

A few days ago when trying to use the add-on "remove duplicates" gives me a "connection refused" error, only works in a incognito mode. (i have purchased the plugin)

Hello Emmanuel,

Thank you for contacting us. This issue might occur due to the problems on the Google server where our add-ons are located. Please try to reinstall the tool by following these steps:

1. Sign out of all Google accounts and log back in only under the account you used to grant permissions to the add-on.
2. Open your spreadsheet and remove the add-on from your Google Sheets (Add-ons > Manage add-ons).
3. Reload the spreadsheet, go to Add-ons > Get add-ons, and install Remove Duplicates back.

Hope this will work for you. If you still have difficulties, please contact us at support@ablebits.com for further assistance.

The 'SUM(valuesByColor...' functionality has always been very good but seems to have stopped working over the last few days.
Now all cells with the formula in are giving the error message:
Error
Unknown function: 'valuesByColor'.

Has anyone else experienced this or knows how to fix?

Katerina Bespalaya (Ablebits Team) says:
February 14, 2020 at 1:13 pm

Hi Giles,

Sorry to hear that you are having difficulties with our add-on. Please first make sure that you are logged in only under the account you used to grant permissions to the add-on. Please sign out of all other Google accounts due to an issue on the side of Google, log back in only under the subscribed account and try to reproduce the issue. If the problem persists, then please contact support@ablebits.com for further assistance. Thank you.

Hi,
I have a paid version of Remove Duplicates. When I navigate to Add-ons in a G Sheet, the tool is greyed out and I am unable to access. I tried uninstalling and reinstalling, logging out and back in and nothing works.

Ekaterina Pechyonkina (Ablebits Team) says:
January 21, 2020 at 8:30 am

Hi Kyle,

Thank you for contacting us. Sorry to hear you having issues with our add-on. I kindly ask you to take a screenshot of the tool greyed out and send it to support@ablebits.com.

We'll do our best to help.

Hi there!

I am trying to use Combine Sheets inside a Shared Drive (formerly Team Drives), but it won't let me navigate to anything outside of "My Drive" in order to select files. Using the search feature, I can find a few of the files I need, but not all of them. Any idea why the search would return a few files that are in the Shared Drive but not others? And is there a way for me to access all of the Shared Drive files through the file-picker interface so that I can combine the sheets I need?

Thanks!
Abigail

Any name with the letter "I" for the middle initial Split names does not Split the name to First middle and last name. It only fills the last name column with the persons first name.

First Name Middle Name Last Name
GERTRUDE I CHERRY GERTRUDE
KIP I PERGANDE KIP
LEE I VINES LEE
JOSE I MONTES JOSE

Ekaterina Pechyonkina (Ablebits Team) says:
December 29, 2019 at 9:35 am

Hello Olaf,

Thank you for reporting the issue. Our developer team will investigate it thoroughly and respond to you. Thank you.

Hey There,

Just bought the 'remove duplicates' add on, and my scenario stopped working. Now I'm unable to save scenarios at all. A bit frustrating to have functionality change after purchase.

Thanks

I just purchased the add on as my trial expired but it's not working.
It "works" but in the second column, it just duplicates the same exact first and last name in the second column. Please help!

Bart Stuart Mortensen says:
July 12, 2019 at 3:47 pm

In the merge sheet add on, I am able to save the scenario. When I upgraded to power tools I am no longer able. Is there a fix planned for this?

Hello Bart,

At the moment, scenarios are available for single Merge Sheets only. We're working on transferring them to Power Tools, but I can't give you exact timing. I can email you back once scenarios are added there.

Please accept my sincere apologies for any inconvenience.

Peter Schmidt says:
May 27, 2019 at 4:42 am

Hi,

I have installed the powertools addon and wanted to remove empty columns and rows from all pages, but it does not do the job, just for the current page. Can it be done in bulk, so if I have 100 sheets in google sheets then it removes all empty columns and sheets for all sheets?

Than you.
Petr

Hi Peter,

You are correct, the current version removes empty columns and rows only from the currently active sheet.

I will forward your request to our developers to check if it's technically possible to implement the feature.
Though I can't give you any timing, if you'd like, I can let you know when there's any news.

Hi,
I am just following your example above to calculate the coloured boxes.
However, it kept showing 1 for COUNTA and 0 for COUNT.
I used this
=COUNT(valuesByCellColor("red", A8, M4:M7))
=COUNT(valuesByColor("#00ff00", "#000000", M4:M7))
Both does not work

Hi Bloom,

What example are you referring to?
Our tool creates valuesByColor function, not valuesByCellColor. Also, COUNT checks for cells with numeric records only. To make the formula consider textual and other cells as well, please use COUNTA.

If you're still unable to get it to work, for us to be able to help you, please share a sample spreadsheet with us (support@4-bits.com) with your source data and the result you expect to get. Please shorten the table to 10-20 rows.
Note. We keep support@4-bits.com for file sharing only and don't monitor its Inbox. Please do not email there.

We'll look into your task. Thank you.

mark van den bergen says:
April 16, 2019 at 9:16 am

I was hoping power tools could convert this formula to values
=VLOOKUP(A8,N:AR,4,false)
Converted to values should return an image thumbnail something like this:
=IMAGE("https://drive.google.com/uc?id=1blakDlwDEkxVq99cO9-lPbHMublabla")
But unfortunately powertools returns a blank cell.

Thank you for contacting us, Mark.
Could you please share a small sample spreadsheet with us (support@4-bits.com) with your source data and the result you expect to get? I kindly ask you to shorten the table(s) to 10-20 rows. We'll look into your task and see if there are ways to solve it with our tools.
Thank you.

Alexander Ledig says:
February 25, 2019 at 1:11 pm

there is no place to insert license key: Select Add-ons > Power Tools > Enter license key in the Google Sheets menu.
this just doesnt exist

Hello Alexander,
Thank you for contacting us.

If you don't see the Enter license key option in the menu, most likely the add-on is already unlocked. Please run the tool and click the key icon at its bottom - you should see your license information there.
Otherwise, please email us to support@ablebits.com with the screenshots of the issue.
We'll do our best to help you activate.

I installed two addons in my spreadsheet and now I can not delete them. The addons are "Find Fuzzy Matches" and "Flookup", thanks for your time.

Alejandro Sanchez says:
February 19, 2019 at 6:59 pm

When using the find and replace tool in the power tools product, it has been telling me for all queries no matter how small or large, that there is no matching data found. But there is data. Do you know what might be goign on? Thanks

Hello Alejandro,

Please note that there is currently an issue on the side of Google Sheets that occurs when you are logged in under more than one account. I kindly ask you to sign out and log back in only under the account you used to grant permissions to the add-on.

If this doesn’t solve the problem, would it be possible for you to share a sample sheet with a couple of lines of your data with support@4-bits.com for testing?

We'll do our best to help you.

Post a comment

Seen by everyone, do not publish license keys and sensitive personal info!

If you have any questions or issues with this add-in, please feel free to post your concerns in the comments area. As soon as we answer, a notification message will be sent to your e-mail. If you do not want to share your thoughts in public, please contact us at support@ablebits.com.