Responses
Clear > Remove empty rows & columns > Remove empty rows
and
Remove unused rows
Has no effect on my sheet.
Hello Mike,
Could you please send us any screenshots or a short video illustrating the problem you have at support@ablebits.com?
We'll look into this issue. Thank you.
I cannot sort a combined spreadsheet by date. the sort function doesn't work with the formula using IMPORTRANGE. I have it as a formula so it consistently update each time someone puts new info in the original sheet
Hello Renee,
Thank you for the question.
You can wrap the Combine Sheets formula in the QUERY function. Make sure to specify the column to sort by at the end of the entire formula. If you'd like to specify the sorting order as well, just add “Asc” for ascending or “Desc” for descending:
"select * order by Col11 Asc")
If you can't get the desired result, please contact us at support@ablebits.com and send screenshots showing the issue. We will do our best to help you out.
Thank you.
I have an issue (that seems to be partially also due to the limitations of google sheets). In case you have two columns, that are not equal by size, but you need to cross check them and colour all the entries from the first column in the second (i.e., find duplicates in the second column), the formatting applies only to the part of the second column that lays past the final entry of the first column, and, therefore, out of 30 entries I needed coloured, only 20 ever did get formatted. And I know for a fact, that all 30 entries are present within the second column (the first column was 30 entries long and the second around 200+). I had to actually export everything to excell. Excell calculated everything properly. I'm not entirely sure whether this is due to a limitation within Google sheets itself, or withing the plugin.
Hello Amelia,
Thank you for your comment. Please ensure that the entire range is selected in the add-on instead of just a part of it. Additionally, it would be helpful if you could send us (support@ablebits.com) screenshots of the problem so we can better understand the issue.
i've purchased and get order number. But there are no activation link to my email.
I also have sent email to support@ablebits.com but there are no answer.
Hello Furqon,
Our support service specialists have sent you a few emails so far. If you don't see them in your Inbox, please also check your Spam/Junk/Trash email folders. Thank you.
"Function by color" is blanking cells. Since I've installed this extension - when I select a cell, if I'm idle too long, the cell will clear and a blinking cursor will appear. This is wrecking my spreadsheets, and was not an issue before installing this extension, nor since removing it. A shame - it does what it's intended for quite well...
Hello Christopher,
Thank you for your comment. 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. We kindly ask you to sign out and log in only under the account you used to grant permissions to the add-on and try to reproduce the issue.
If this doesn't help, please record a short video showing the problem and send it to support@ablebits.com for investigation. Thank you.
I am using Advanced Find and Replace tool.
When I want to replace a bit, the tool is automatically adding 2 spaces behind the bit I want to replace, so of course there is an error. I have tried everything: restart etc. But It is only adding two spaces by replacing with a new tab.
Thank you for your feedback, Sandy. Sorry, it's not entirely clear what you mean by "It is only adding two spaces by replacing with a new tab". I kindly ask you to email our support team directly (support@ablebits.com) with the screenshots or the video of the problem. Thank you.
RE: Google Sheets - Sheets Manager add-on
When using Sheets Manager to copy a sheets to a new document, the new document's named ranges are broken.
Example: The original document named range "User Names" on "Sheet2" referencing "Sheet2!B2:B4".
Problem 1: In the new document it would be renamed to "Sheet2!User Names", yet still accurately referencing "Sheet2!B2:B4".
Problem 2: Neither the old ("User Names") or new name ("Sheet2!User Names") works in the formulas.
Problem 3: Renaming the new name back to the old name pulls up an error saying that the name already exists.
I love your work and appreciate what you do.
Thank you for your feedback, Craig.
Yet, I'm afraid I'm unable to reproduce the problem you described. The copied sheet features the named range correctly and it works in formulas. Please email our support team directly (support@ablebits.com) with the video demonstrating the problem. Thank you.
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"
Hello,
Thank you for contacting us.
Please try to reload the spreadsheet and see if the option to run the tool appears in the menu. If this doesn't help, please contact us at support@ablebits.com and specify what browser and operating system you use.
We'll do our best to assist you.
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.
Hello Masih,
Thank you for your message.
Sorry, it is not quite clear what limitations you refer to in your message. Google doesn't mention any limitations for comments. Please refer to here for more information.
If you have any issues with our add-on, please contact us at support@ablebits.com and we will do our best to help. Thank you.
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.
Hello Sagar,
Please specify what tool exactly you used and what options you chose on each step of the add-on. The screenshots with the selected options and with the data you had before and after merging would help a lot. Please send all these details to us by email, support@ablebits.com, and we'll try to assist you further.
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?!
Hello Erin,
Thank you for your comment. There is currently an issue on the side of Google Sheets that occurs when you are logged in under more than one account. This may force the tool to lose your key. Unfortunately, we can't control or bypass this issue, so I kindly ask you to sign out and log back in only under the subscribed account.
If this doesn't help, please contact us at support@ablebits.com.
I would like to remove auto pop up of Power tool. I already uninstall this app through extensions
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
Hello Courtney,
Thank you for your message.
Please refer to this section above for possible solution.
Thank you.
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.
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.
Dear Andy,
Thank you for your comment. This is a known issue, please check the possible solutions on this help page.
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.
Hello Todd,
Thank you for your comment. Sorry to hear that you've faced difficulties of this kind. For us to be able to assist you better, please take a screenshot of the error message and send it to support@ablebits.com. We'll do our best to resolve the issue.
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
Thank you for your comment, Peter.
First, please make sure it's not this issue with the Chrome browser.
Then, if your browser is not Chrome, please email the screenshots of the issue you're having to our support team directly: support@ablebits.com. They will help you out.
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?
Hello Beth,
Thank you for your comment.
For us to be able to help you better, please send us a few screenshots showing: 1 - the data you process; 2 - the settings you choose for the add-on; 3 - the formula you paste; 4 - the error message you get. You can email the details to support@ablebits.com. We'll look into the issue and try to help.
My Remove duplicates option is not showing up anymore. My license is active until March 2024. Not sure why I am not able to access this feature.
Hello Rachit,
Sorry to hear that you have faced difficulties of this king with our add-on. Please email us at support@ablebits.com and describe the problem in detail. Any screenshots illustrating the issue will help a lot.
the side bar won't load, this happens about every 6 months and I forgot what i did to fix it last time
Hello Brian,
Thank you for your comment. 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. In case the problem occurs again, please email us at support@ablebits.com. We'll do our best to help.
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.
Formulas are not working
Hello Ben,
Could you please specify what Ablebits tool you've tried to use exactly and describe in more detail what has gone wrong? Any screenshots illustrating the problem would help a lot. Please email all the details to support@ablebits.com. We'll look into this issue. Thank you.
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 suddenly can’t move rows or columns! I made everything possible, reinstalled, deleted the app and downloaded again, but nothing seems to help.
Hello Elizabeth,
Thank you for the comment. Please send a screenshot illustrating the issue to support@ablebits.com.
The combine sheet plugin just stops and doesn't process. This is very frustrating and defeats the entire point of the plugin.
Hello Michael.
Thank you for the message.
Please contact us at support@ablebits.com and send us a small video or some screenshots illustrating what you do and the error you get. We'll look into the issue and do our best to assist you.
Thank you.
I've combined my first sheets successfully, however I'm getting an error when adding new sheets to the existing combined data.
Error Message:
Sorry, the add-on couldn't add more data to the formula.
Hello,
Thank you for your comment. Please email us at support@ablebits.com with a screenshot of the error message you are getting. We'll do our best to help.
I do not see start button on the power tools selection, I can't start it.
Hello Yap,
Thank you for contacting us.
Please try to reload the spreadsheet and see if the option to run the tool appears in the menu. If this doesn't help, please specify what browser and operating system you use.
We'll do our best to assist you.
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?
Hello Ramsey,
Please send the screenshots of the options you choose on each step of the add-on to support@ablebits.com. I will do my best to help.
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.
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?
Hi Hamza,
Thank you for your comment.
Could you please send us a screenshot of the error message you are getting when extracting URLs with our add-on at support@ablebits.com? Also, please specify what options you choose for the add-on.
We'll try to reproduce the issue on our side. Thank you.
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
Hello ASTRID,
Thank you for your comment. Please email us at support@ablebits.com with the screenshots of your source data and the expected result. Please also send us the screenshots of each step of the add-on showing the options you select.
We'll do our best to help you.
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.
my power tools are not working.Am woried because i just used this extention for 2 days
Hello Rafa,
Thank you for your comment. Sorry to hear that you've faced difficulties with our add-on.
For us to be able to resolve the issue, please email us at support@ablebits.com with a detailed description of the problem and send some screenshots illustrating it. Thank you.
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
Hello Justin,
Thank you for reporting a problem to us.
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. Thank you.
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
Hello Jack,
Thank you for contacting us. When you renew your subscription, your activation key remains the same. I've also just resent the key once again to your billing email address. If you don't see an email for some reason, please send a message to support@ablebits.com directly.
#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.
The Advanced Find and Replace is not working in the standalone plugin or the Power tools Add-on
Hello Ren,
Thank you for your comment.
Could you please describe what exactly is not working? Any screenshots or a short video illustrating the problem would help a lot. Please send the details to us by email, support@ablebits.com. We'll look into this issue. Thank you.
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.
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.
Hi Lisa,
If it's possible, please share an editable copy of your spreadsheet with us (support@apps4gs.com) and include the screenshots of the options you choose on each step of the add-on.We will reproduce the problem and find its cause.
Split Sheet is stuck on loading on 5%. Stays on 5% for already 10 minutes. File size: 100k rows.
Hello Yuma,
This may happen due to an issue with multiple Google accounts on Google side. Please sign out and log back in with an account under which you want to work with your spreadsheet.
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?
Hello Thomas,
Thank you for your comment. Please note that we support only Ablebits products, while Mail Merge for Gmail is a product of a different vendor, Digital Inspiration. Please contact them directly.
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
Hi Jared,
Thank you for contacting us. Please specify if you merge cells with our add-on or using a standard Google Sheets tool? Also, please create a short video illustrating the issue and send it to support@ablebits.com. It will help us understand the problem and provide you with the best solution. Thank you.
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.
Hello Matt,
Thank you for the comment. We have requested some additional details in a separate email. Please check your Inbox and let us know at support@ablebits.com.
Did not work.
Only Help available after install.
I do not want to search your FAQ for the first step.
Hello Elisa,
Thank you for your comment. Please try to reload the spreadsheet and see if the option to run the tool appears in the menu.
If this doesn't help, please email us at support@ablebits.com and specify what browser and operating system you use. We'll do our best to assist you.
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.
Hello Kjartan,
I'm happy to let you know that we fixed this issue. The updated version of the add-on with the fix should already be available to you.
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
Hello Marc,
Thank you for your comment.
I'm sorry it's currently impossible to run a saved scenario automatically for Merge Sheets. At the moment scenarios can be scheduled to run automatically at a certain time a day only for the Remove Duplicate Rows tool.
However, since this is a common request, we consider adding trigger support for other add-ons as well.
No ability to select nothing for spacing in the tool.
Hello Sean,
Thank you for your comment. Could you please describe in more detail what functionality exactly is missing? What tool have you tried?
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
Hello Krystian,
Sorry you are having issues with the tool. I have emailed you the details we need to investigate it. Please check your inbox.
Looking forward to your reply.
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.
MERGE SHEETS IS NOT WORKING
Hello POORNIMA,
Thank you for contacting us. Please describe the issue in more detail and send the screenshots of the problem to support@ablebits.com. I will do my best to help.
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.
Hello Alexander,
Thank you for your comment. Sorry to hear that you are having difficulties of this kind.
We've got your email with the details of your order and checked your subscription in our database. Your key should be active now. Please try to activate the add-on once again.
If you still have any difficulties, please email us at support@ablebits.com for further assistance.
my addon doesnt work propertly
Hello Arkadyi,
Thank you for your comment.
Could you please specify what add-on you tried to use exactly and describe what went wrong? Any screenshots illustrating the problem would help a lot. You can send all the details to support@ablebits.com.
We'll look into this issue and try to help. Thank you.
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.
Count using the color as criteria is not working
Hello Ernesto,
Thank you for contacting us. Please describe the issue in more detail and send the screenshots of your data, formula bar and the result you get to support@ablebits.com. We will do our best to help asap.
Whenever I click START, the menu won't appear and error states that drive.google.com refused to connect.
Hello Ismael,
Thank you for your comment. 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 this doesn't help, please email us at support@ablebits.com.
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
Hello Martina,
Thank you for your comment. I’m really sorry that you are having difficulties of this kind.
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 email us at support@ablebits.com.
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.
Please add Jr. (and its spelling variations) as a suffix during name splitting.
Hello,
Thank you for your comment. I have passed your request on to our developers.
Thank you.
There is no start option after installing add-on extension called Power Tools
Hello,
Thank you for your comment.
Please try to reload the spreadsheet and see if the option to run the tool appears in the menu. If this doesn't help, then please email us at support@ablebits.com and specify what browser and operating system you use.
We'll do our best to help you further.
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.
last step is not working
Hello Emerson,
Thank you for you comment.
For us to be able to help you better, please email us at support@ablebits.com and specify what tool you tried to use exactly and what went wrong. Any screenshots illustrating the problem would help a lot.
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.
Hello Fred,
Thank you for your comment. I am sorry, we haven't been able to reproduce the issue on our side, the add-on works as expected.
For us to be able to help you better, I've send you an email requesting some additional information. Please email us back with the requested details at support@ablebits.com. Thank you.
I installed but for doing in another sheet i didn't get it
Hello Fathima,
Thank you for your comment. Please have a look at this guide to start the add-on:
https://www.ablebits.com/docs/google-sheets-power-tools/#run-addon
If your problem is different, please send us a screenshot of the issue to support@ablebits.com.
Just downloaded the Split add-on but it's not letting me select which column to split it from
please advise
Hello Kimba,
Thank you for your message. 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.
If the issue persists, please email us at support@ablebits.com.
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.
Hello Jeremiah,
Thank you for the comment. Please activate the add-on using your current license key (I have just resent it to your email address). The pop-up won't bother you any longer.
Estimados me carga solo en english y yo no se hablar english necesito que sea en español como cambiar el idioma?
Hello Jose,
Thank you for your comment.
I am sorry, but our software is available only in English. If you have any questions or need some assistance with our tools, please email us at support@ablebits.com. We'll be happy to help.
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
is there seriously no way to disable this? most annoying thing ever
Hello,
Please send us a screenshot of the problem at support@ablebits.com. We will be glad to help.
THE EXTENSION WONT OPEN FULLY
Hello,
Thank you for your comment. Please specify what tool you use and send us a screenshot of the problem to support@ablebits.com. We will do our best to help.
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.
Justin,
Thank you for contacting us. 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. Please let us know about the result.
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
Hello Julia,
Thank you for contacting us.
For us to be able to assist you better, we need to know more details. If it is possible, please make a video showing the process of combining along with the result you get to support@ablebits.com. We will do our best to help.
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?
Hi Wai,
Thank you for contacting us. For us to understand the problem better, please send us the screenshots of this error message and the options you choose on each step of the add-on to support@ablebits.com. We will try to reproduce the issue and find its cause.
Nothing works. Whatever I click, nothing happens.
Hello Bruna,
Thank you for your comment.
Could you please specify what Ablebits tool exactly you've tried to use and describe the problem you've faced in more detail? Any screenshots illustrating the issue would help a lot. Please email the details to support@ablebits.com.
We'll look into this issue and help you further. Thank you.
When I try to compare columns, it says server error and doesnt do it. Can you please fix this. thanks
Hello Lindsey,
Thank you for contacting us. Could you please send a screenshot of the error message to support@ablebits.com? We will do our best to assist.
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.
Hello Aman,
I'm happy to let you know that the problem you reported has been fixed. The updated version of Sheets Manager should already be available to you.
Feel free to contact us back if you have any questions or need any assistance.
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.
Thank you for your feedback, Davis!
We tried many different cases in order to find a workaround for the issue with multiple accounts. Unfortunately, as long as the Google team don't fix it on their end, there's nothing we can do since any solution may stop working at any moment.
Anyways, we appreciate your time and help on the matter :) Hope you enjoy Table Styles! :)
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.
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.
I've tried this fix and the merge sheets function will still not work for me
Hello Ben,
Sorry to know you are having difficulties with our tool. For us to be able to assist you better, please send a screenshot of the error message you get to support@ablebits.com.
Hi my power tool refused to connect. What to do?
Hello Shweta,
I'm sorry to hear that you are having difficulties with our product. 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.
Please let us know about the result at support@ablebits.com. Thank you.
Remove Duplicates not working properly
Hello Kaye,
Thank you for contacting us. For us to be able to assist you better, please send the details listed in the separate email I've just sent to your address. Thank you in advance for your cooperation.
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.
Hi Kew,
Thank you for reporting the problem. Also, we request your assistance in reproducing the issue. I have just sent the details to you via email.
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?
Hello Benson,
Sorry to hear you are having difficulties with our add-on. Please makes sure to follow the solutions described here:
https://www.ablebits.com/docs/google-sheets-add-ons-known-issues/#cannot-uninstall
Please let us know about the result by sending a message to support@ablebits.com.
por alguna razon instalo el complemento "Autocrat" y no me permite abrir...quisiera saber que sucede
Gracias
Hello Rodney,
Thank you for contacting us. I'm sorry, it is not quite clear which Ablebits add-on you use. Please tell me what add-on you've installed and send us a screenshot of the problem to support@ablebits.com. We will do our best to assist asap.
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.
Hello Jeff,
Thank you for your message. You see, 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.
If you still have any difficulties with the add-on, please email us at support@ablebits.com. We'll do our best to 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
Hello Truong,
Thank you for your message. You can Unpin the add-on by clicking on the corresponding icon at the bottom of the add-on's pane to disable auto-start.
As for the white bar with "no result", could you please send us a screenshot of the issue to support@ablebits.com? This will help us to understand it better. Thank you in advance.
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,
Thank you for contacting us and reporting the problem.
Unfortunately, there are some problems on the Google side that interfered with our add-ons. Please try to run the add-on in another browser, hope it will work for you!
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.
I continue to get an Error message when I attempt to get the sum of the column with cells of a specific color.
Hello Jessica,
Thank you for contacting us. Please send me a screenshot of the error message you get to support@ablebits.com. I will do my best to help.
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.
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.
Hi I have tried to update a file, which selects the same values but it does not update, can not use color to highlight what has done.
Hi Sabri,
Thank you for contacting us. Please describe what add-on you use and send us the screenshots of the options you choose to support@ablebits.com. I will do my best to help.
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.
Hello Brittany,
Thank you for contacting us. I'm really sorry you are having issues with our add-on. I've just sent you instructions via email.
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,
Thank you for your comment.
If you refer to our Combine Sheets add-on, I am afraid comments and notes are ignored when combining the data. I will forward your request to our developers and they will look into the possibility to implement this functionality. Thank you.
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!
Uppercase each word?
Hello Edward,
Thank you for your comment. We have a Change Case tool in our Power Tools for Google Sheets that can adjust the case of the selected cells in a click. Check out its manual for the step-by-step instructions: https://www.ablebits.com/docs/google-sheets-replace-text/#change-case
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.
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?
Hi Kazi,
Thank you for contacting us. I kindly ask you to confirm if you tried the solutions described here:
https://www.ablebits.com/docs/google-sheets-add-ons-known-issues/#cannot-uninstall
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.
Hello Robert,
Thank you for your message. 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. If the issue persists, please email us at support@ablebits.com.
Hi Guys
Non of my functions like merge sheets and modify texts have been working for the last few days
Hi Kasun,
Thank you for your message. For us to be able to help you better, could you please email us at support@ablebits.com describing the problem you are referring to in more detail? Any screenshots illustrating it would be appreciated. Thank you.
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.
Hello Charles,
Thank you for contacting us. Most likely those cells contain some invisible to the naked eye values like spaces, line breaks or, maybe, unprinted characters. I'd recommend you running our Remove tool first to get rid of such symbols and then use Merge Values once again, that should work.
If you have any questions, do not hesitate to address them to support@ablebits.com. Thank you.
It gets stuck all the time. Doesn't work.
Hello Enric,
Thank you for sharing your experience. Please specify what tool you use and when exactly the add-on stucks. We will do our best to assist.
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.
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.
Hello Stephen,
Thank you for contacting us. If you have already purchased a subscription, please send us your order ID/license key to support@ablebits.com.
In case you are only testing the tool, please keep in mind that once your trial period expires, you'll be able to use the add-on just once a day. Thank you.
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?
Toby,
Unfortunately, we cannot bypass the limitations of the standard Google Sheets function used in the add-on and cannot offer you a workaround. Please find more information about the QUERY function and its limitations on this page.
After starting shows a crashed screen and Gets a message "unable to connect drive".
Hello Suchita,
Thank you for your message. 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.
If the issue persists, please do not hesitate to email us at support@ablebits.com.
I cant use power tools, the only option I have is HELP. I don't see tools.
Hello Velimir,
Thank you for contacting us. Please try to reload the spreadsheet and see if the option to run the tool appears in the menu.
If this doesn't help, please send us your browser and operating system to support@ablebits.com. We'll do our best to assist you.
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
Hello Useph,
Thank you for contacting us. Could you please specify what tool you used exactly and describe what went wrong? Any screenshots illustrating the problem would help a lot. Please send them to support@ablebits.com, we'll look into this issue and try to help. 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.
Hello,
I'm getting an error that "drive.google.com refused to connect" - I hope you can help!
Hello Conor,
Thank you for contacting us. 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 try to reproduce the issue.
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.
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.
Hello Scott,
Thank you for contacting us. We have just replied to you via email, please check your Inbox. Thank you.
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
Hello,
Thank you for your comment. I am sorry, since your message contained some personal details, i.e. your phone number, we had to edit it and removed the personal information.
As for the activation of the add-on, please follow the steps described on this help page:
https://www.ablebits.com/docs/google-sheets-add-ons-activation/
If you need any further assistance, feel free to contact us again.
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?
Thank you for contacting us. We have just replied to you by email. If you do not see our message in your Inbox, please check your Spam/Junk/Trash email folders.
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?
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.
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
Hello Abigail,
Thank you for contacting us. For us to be able to understand the problem better, please specify what Shared Drive you mean. Any screenshot illustrating the way you search for the necessary files will help a lot. Thank you.
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
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
Hello Richard,
Thank you for contacting us.
We have just replied to you via email. Please provide us with the requested information and we’ll do our best to help. Thank you.
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!
Hello Erica,
Thank you for contacting us. Sorry to hear you've encountered difficulties with our add-on.
Our customer service assistant will reply to you by email.
Thank you for understanding.
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.
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.
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.
Add Reminders Google Sheets add-on encountered a problem in your setting, but
Hello Digamber,
I'm sorry but Add Reminders is not our add-on. Please contact the tool's support team regarding the issue: support@add-reminders.com
Thank you.
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.
Hi José,
Thank you for your question.
To uninstall add-ons from your Google Sheets, open any spreadsheet, go to Add-ons > Manage add-on, find the tool in the list and choose to Manage > Remove it.
If you need any further assistance, please email us to support@ablebits.com.
Thank you.
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!
