Google Trang tính được chia sẻ không cập nhật

Daria Markelova (Nhóm Ablebits) nói.

Xin chào Thomas,

Cảm ơn bình luận của bạn. Xin lưu ý rằng chúng tôi chỉ hỗ trợ các sản phẩm Ablebits, trong khi Trộn thư cho Gmail là sản phẩm của một nhà cung cấp khác, Digital Inspiration. Vui lòng liên hệ trực tiếp với họ

Daria Markelova (Nhóm Ablebits) nói.

Chào Jared,

Cám ơn bạn đã liên lạc với chúng tôi. Vui lòng chỉ định xem bạn hợp nhất các ô bằng tiện ích bổ sung của chúng tôi hay sử dụng công cụ Google Trang tính tiêu chuẩn? . com. Nó sẽ giúp chúng tôi hiểu vấn đề và cung cấp cho bạn giải pháp tốt nhất. Cảm ơn bạn

Ekaterina Pechyonkina (Nhóm Ablebits) nói.

Xin chào Matt,

Cảm ơn bạn đã bình luận. Chúng tôi đã yêu cầu một số chi tiết bổ sung trong một email riêng. Vui lòng kiểm tra Hộp thư đến của bạn và cho chúng tôi biết tại support@ablebits. com

Daria Markelova (Nhóm Ablebits) nói.

Xin chào Elisa,

Cảm ơn bạn đã nhận xét. Vui lòng thử tải lại bảng tính và xem tùy chọn chạy công cụ có xuất hiện trong menu không.
Nếu cách này không hiệu quả, vui lòng gửi email cho chúng tôi theo địa chỉ support@ablebits. com và chỉ định trình duyệt và hệ điều hành bạn sử dụng. Chúng tôi sẽ cố gắng hết sức để hỗ trợ bạn.

Katerina Bespalaya (Nhóm Ablebits) nói.

Xin chào Kjartan,

Cảm ơn bình luận của bạn

Chúng tôi đã có thể tái tạo sự cố mà bạn mô tả và các nhà phát triển của chúng tôi sẽ khắc phục sự cố này trong phiên bản tiếp theo của tiện ích bổ sung

Trong thời gian chờ đợi, vui lòng sử dụng các phạm vi tiêu chuẩn trong công thức của bạn, e. g. $AK$3. $AZ$3 thay vì $AK$3. $3

Xin lỗi vì sự bất tiện gây ra

Katerina Bespalaya (Nhóm Ablebits) nói.

Xin chào Marc,

Cảm ơn bình luận của bạn

Tôi rất tiếc, hiện tại không thể tự động chạy kịch bản đã lưu cho Hợp nhất Trang tính. Hiện tại, các kịch bản có thể được lên lịch để chạy tự động vào một thời điểm nhất định trong ngày chỉ dành cho công cụ Xóa các hàng trùng lặp

Tuy nhiên, vì đây là một yêu cầu phổ biến nên chúng tôi cũng xem xét thêm hỗ trợ trình kích hoạt cho các tiện ích bổ sung khác

Ekaterina Pechyonkina (Nhóm Ablebits) nói.

Xin chào Andrea,

Xin lỗi bạn đang gặp sự cố với tiện ích bổ sung. Xin lưu ý rằng hiện tại có một vấn đề về phía Google xảy ra khi bạn đăng nhập bằng nhiều tài khoản. Tôi vui lòng yêu cầu bạn đăng xuất và chỉ đăng nhập lại bằng tài khoản bạn đã sử dụng để cấp quyền cho tiện ích bổ sung và cố gắng tái tạo sự cố

Nếu sự cố vẫn tiếp diễn, vui lòng gửi ảnh chụp màn hình sự cố tới support@ablebits. com. Chúng tôi sẽ cố gắng hết sức để giúp đỡ

Katerina Bespalaya (Nhóm Ablebits) nói.

Xin chào Alexander,

Cảm ơn bình luận của bạn. Rất tiếc khi biết rằng bạn đang gặp khó khăn kiểu này

Chúng tôi đã nhận được email của bạn với các chi tiết về đơn đặt hàng của bạn và đã kiểm tra đăng ký của bạn trong cơ sở dữ liệu của chúng tôi. Khóa của bạn sẽ hoạt động ngay bây giờ. Vui lòng thử kích hoạt tiện ích bổ sung một lần nữa

Nếu bạn vẫn gặp bất kỳ khó khăn nào, vui lòng gửi email cho chúng tôi theo địa chỉ support@ablebits. com để được hỗ trợ thêm

Daria Markelova (Nhóm Ablebits) nói.

Hello HUY MAI,

Thank you for your comment. Có vẻ như đã xảy ra sự cố với kết nối Internet của bạn

Vui lòng thử xóa bộ nhớ cache trong trình duyệt của bạn (đây là các bước dành cho tất cả các trình duyệt) và khởi động lại bộ định tuyến của bạn

Bộ lọc proxy của bạn cũng có thể chặn kết nối. Đảm bảo đưa các URL sau vào danh sách trắng.
tài liệu. Google. com
aapgate. khả thi. com
cdn. ứng dụng4gs. com
googleusercontent. com

Nếu điều này không giúp được gì, vui lòng liên hệ với nhà cung cấp Internet của bạn

Xin lỗi chúng tôi không thể hỗ trợ bạn nhiều hơn

Daria Markelova (Nhóm Ablebits) nói.

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

Daria Markelova (Nhóm Ablebits) nói.

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

Katerina Bespalaya (Nhóm Ablebits) nói.

Hello Michael,

Cảm ơn bình luận của bạn. Rất tiếc khi biết rằng bạn đang gặp khó khăn kiểu này

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

Katerina Bespalaya (Nhóm Ablebits) nói.

Hello,

Cảm ơn bình luận của bạn. Tôi đã chuyển yêu cầu của bạn cho các nhà phát triển của chúng tôi

Ekaterina Pechyonkina (Nhóm Ablebits) nói.

Xin chào Bill,

Cảm ơn bạn đã báo cáo sự cố. Trước tiên, xin lưu ý rằng hiện tại có một sự cố xảy ra ở phía Google Trang tính khi bạn đăng nhập bằng nhiều tài khoản. Tôi vui lòng yêu cầu bạn đăng xuất và chỉ đăng nhập lại bằng tài khoản bạn đã sử dụng để cấp quyền cho tiện ích bổ sung.
Nếu cách này không hiệu quả, hãy thử xóa bộ nhớ cache trong trình duyệt của bạn. Bạn có thể tìm thấy hướng dẫn cho tất cả các trình duyệt tại đây. https. //www. làm mới bộ nhớ cache của bạn. com/vi/nhà/

Trong trường hợp sự cố vẫn tiếp diễn, vui lòng gửi ảnh chụp màn hình lỗi bạn gặp phải tới support@ablebits. com

Katerina Bespalaya (Nhóm Ablebits) nói.

Hello Won Suh,

Cảm ơn bình luận của bạn

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

Katerina Bespalaya (Nhóm Ablebits) nói.

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

Daria Markelova (Nhóm Ablebits) nói.

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

Ekaterina Pechyonkina (Nhóm Ablebits) nói.

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

Daria Markelova (Nhóm Ablebits) nói.

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

Natalia Sharashova (Ablebits Team) says.

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. Tôi cũng sẽ sớm thêm thông tin này vào trang này.
Chúng tôi sẽ đánh giá rất cao nếu bạn cũng có thể mở vấn đề và gắn dấu sao cho vấn đề đó và thậm chí có thể nhận xét để thu hút sự chú ý của nhóm Google đến vấn đề này nhanh hơn.

You can also copy only the following part from the formula. =valuesByColor("vôi", "đen", A4. A61), và dán nó vào một cột trống trong cùng một tệp. Sau đó gửi cho chúng tôi ảnh chụp màn hình của những gì nó trả về. Nó sẽ giúp nhóm nhà phát triển của chúng tôi tìm hiểu sâu hơn và báo cáo sự cố cho Google một cách chính xác

Tin vui là tất cả các công thức đều tải thành công trong một khoảng thời gian ngắn. 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

Ekaterina Pechyonkina (Nhóm Ablebits) nói.

Xin chào 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

Ekaterina Pechyonkina (Nhóm Ablebits) nói.

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

Ekaterina Pechyonkina (Nhóm Ablebits) nói.

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

Ekaterina Pechyonkina (Nhóm Ablebits) nói.

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

Katerina Bespalaya (Nhóm Ablebits) nói.

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

Natalia Sharashova (Ablebits Team) says.

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

Natalia Sharashova (Ablebits Team) says.

Thank you for your feedback, Davis

We tried many different cases in order to find a workaround for the issue with multiple accounts. Thật không may, miễn là nhóm Google không khắc phục vấn đề đó từ phía họ, thì chúng tôi không thể làm gì vì bất kỳ giải pháp nào cũng có thể ngừng hoạt động bất cứ lúc nào

Anyways, we appreciate your time and help on the matter 🙂 Hope you enjoy Table Styles. 🙂

Katerina Bespalaya (Nhóm Ablebits) nói.

Hello Alvin,

Cảm ơn bình luận của bạn

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

Katerina Bespalaya (Nhóm Ablebits) nói.

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

Katerina Bespalaya (Nhóm Ablebits) nói.

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

Katerina Bespalaya (Nhóm Ablebits) nói.

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

Nếu bạn vẫn gặp bất kỳ khó khăn nào, vui lòng gửi email cho chúng tôi theo địa chỉ support@ablebits. com để được hỗ trợ thêm

Ben says.

I've tried this fix and the merge sheets function will still not work for me

Ekaterina Pechyonkina (Nhóm Ablebits) nói.

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

Daria Markelova (Nhóm Ablebits) nói.

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. Cảm ơn bạn

Ekaterina Pechyonkina (Nhóm Ablebits) nói.

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

Ekaterina Pechyonkina (Nhóm Ablebits) nói.

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

Ekaterina Pechyonkina (Nhóm Ablebits) nói.

Hello Benson,

Sorry to hear you are having difficulties with our add-on. Please makes sure to follow the solutions described here.
https. //www. khả thi. 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

Aksana Pachkouskaya (Ablebits Team) says.

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

Ekaterina Pechyonkina (Nhóm Ablebits) nói.

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. Cảm ơn bạn trước.

Ekaterina Pechyonkina (Nhóm Ablebits) nói.

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

Ekaterina Pechyonkina (Nhóm Ablebits) nói.

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

Natalia Sharashova (Ablebits Team) says.

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

Katerina Bespalaya (Nhóm Ablebits) nói.

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. Sau khi bạn loại bỏ tất cả khoảng trắng thừa trong (các) cột chính, vui lòng thử chạy lại công cụ Split Sheet

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

Ekaterina Pechyonkina (Nhóm Ablebits) nói.

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

Ekaterina Pechyonkina (Nhóm Ablebits) nói.

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

Ekaterina Pechyonkina (Nhóm Ablebits) nói.

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

Katerina Bespalaya (Nhóm Ablebits) nói.

Hello Eric,

Cảm ơn bình luận của bạn

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

Ekaterina Pechyonkina (Nhóm Ablebits) nói.

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

Aksana Pachkouskaya (Ablebits Team) says.

Hello Robert,

Thank you for your message. Hiện tại có một vấn đề về phía Google xảy ra khi bạn đăng nhập bằng nhiều tài khoản. 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

Mary Trifuntova (Ablebits Team) says.

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

Ekaterina Pechyonkina (Nhóm Ablebits) nói.

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.

Ekaterina Pechyonkina (Nhóm Ablebits) nói.

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.

Ekaterina Pechyonkina (Nhóm Ablebits) nói.

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

Katerina Bespalaya (Nhóm Ablebits) nói.

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

Toby says.

November 12, 2020 at 1. 54 pm

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?

Katerina Bespalaya (Nhóm Ablebits) nói.

November 12, 2020 at 2. 37 pm

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

Toby says.

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?

Katerina Bespalaya (Nhóm Ablebits) nói.

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

Mary Trifuntova (Ablebits Team) says.

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

Aksana Pachkouskaya (Ablebits Team) says.

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

Ekaterina Pechyonkina (Nhóm Ablebits) nói.

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

Mary Trifuntova (Ablebits Team) says.

Hello Scott,

Thank you for contacting us. We have just replied to you via email, please check your Inbox. Thank you

Katerina Bespalaya (Nhóm Ablebits) nói.

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

Katerina Bespalaya (Nhóm Ablebits) nói.

Hello Emmanuel,

Cám ơn bạn đã liên lạc với chúng tôi. 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

Katerina Bespalaya (Nhóm Ablebits) nói.

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

Ekaterina Pechyonkina (Nhóm Ablebits) nói.

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

Mary Trifuntova (Ablebits Team) says.

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

Ekaterina Pechyonkina (Nhóm Ablebits) nói.

Hello Olaf,

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

Natalia Sharashova (Ablebits Team) says.

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

Natalia Sharashova (Ablebits Team) says.

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.

Natalia Sharashova (Ablebits Team) says.

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

Natalia Sharashova (Ablebits Team) says.

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.

Natalia Sharashova (Ablebits Team) says.

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.

Natalia Sharashova (Ablebits Team) says.

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.

Mary Trifuntova (Ablebits Team) says.

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?

Why is my Google sheet not syncing?

Why can't I edit a Google sheet that was shared with me?

How can multiple users update a Google Sheet at the same time?

Why isn't my Google Doc updating?