Cara menggunakan google sheets white background

Ekaterina Pechyonkina (Ablebits Team) says:

Hello Adi,

Thank you for contacting us.

Unfortunately, since our valuesByColor returns values ​​from cells, it cannot be wrapped in another condition for another column. We'll make a note of this case as a potential improvement and will see if it's technically possible to implement something like this in the future.

For now, I can only offer to try and use Scripts. Here's an overview of Google Apps Script with a lot of helpful content and links:
https://developers.google.com/apps-script/overview
I wish I could help you better.

Mary Trifuntova (Ablebits Team) says:

Hi Daniel,

Thank you for your comment. First off, it is possible to update the formulas created by the add-on. You may either or manually enter the name of the color from the Google Sheets color palette and the change will be applied.

If this is not exactly what you need, please clarify. If you send us any screenshots illustrating your scenario to [email protected], it'll be very helpful. Thank you!

sunks says:

I start using the app today but it is one of the easy and must well develop for all to use.

Thanks so much

Very easy to understand.

The Gambia, West Africa.

Please try it

Mary Trifuntova (Ablebits Team) says:

Hello Sunks,

Thank you so much for your feedback! We're happy to hear you enjoy using our software.

If it's not too much trouble for you, we would appreciate it if you rate our add-on and write a few words on Google Workspace Marketplace. Your positive feedback motivates us much better than sales numbers. 🙂

Thank you in advance and have a great day!

Mo says:

Ok scratch that, I've figured out how to do it. Now for the even next step, is there a way to create a list that shows me how often each word was mentioned in all the cells with a green background color?

Jack says:

Mo, would you be able to share how you did this

Ekaterina Pechyonkina (Ablebits Team) says:

Hi Kat,

Thank you for contacting us. I'm really sorry but our development team is still working on this feature. We will let you know once it is available. Our apologies for any inconvenience.

Natalia Sharashova (Ablebits Team) says:

Hi Kat,

The recent upgrade of the Function by Color tool lets you process more than one color in one formula. You will still need to create separate formulas for each color, but you can then combine these formulas into a bigger one, like SUM, or COUNT(A), or AVERAGE, etc. and they will work.

anurag says:

its sorted, i can use COUNTA()

Natalia Sharashova (Ablebits Team) says:

Hi Rick,

Thank you for your interest in our product.

It looks like add-ons from G Suite Marketplace are prohibited by your organization on the domain level. Please contact your administrator. He/she should be able to check this in the Google Admin console and whitelist the tool for you or all users if possible.

Mary Trifuntova (Ablebits Team) says:

Hi Pat,
Thank you for contacting us. This problem may be caused by an issue with the way permissions are handled when you use more than one account in Google Sheets. Signing out of all other accounts and logging in just to the account with the subscription should fix this. If you share documents between the accounts, please make sure it is used under the necessary account.

If not, please select the Refresh results under the Function by color in Power Tools. The function should work correctly then.

Katerina Bespalaya (Ablebits Team) says:

Hello Mary,

Please note that our tool can't process more than one color at a time, so you need to enter one formula for each color you want to count.

Besides, 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. Additionally, our tool doesn't support the Theme colors which is a relatively new formatting tool in Google Sheets.

If the locale is set and the the standard Fill colors are used in your spreadsheet, then please contact [email protected] for further assistance.

Katerina Bespalaya (Ablebits Team) says:

Hi Karolina,

I've just sent you an email with the details we need to understand the problem better. Please provide us with the information requested in the email. Thank you.

Karolina says:

I have the same problem, please let me know how to solve it

Mary Trifuntova (Ablebits Team) says:

Hello Karolina,
Thank you for your comment. This problem may be caused by an issue with the way permissions are handled when you use more than one account in Google Sheets. Signing out of all other accounts and logging in just to the account with the subscription should fix this. If you share documents between the accounts, please make sure it is used under the necessary account.

Also, please keep in mind that 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 to check if the function works correctly.

Natalia Sharashova (Ablebits Team) says:

Thank you for contacting us, Karina.

First, due to an issue on the side of Google, please make sure to sign out of all other Google accounts you may be logged in to.

Then, 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 option next to Function by color in Power Tools. The function should work correctly then.

Please let us know if you still have any difficulties.

Natalia Sharashova (Ablebits Team) says:

Thank you for your question, Yatin.

We haven't provided for a way to process more than one colour at a time, so you need to enter one formula for each colour you want to count.
We will consider embedding this possibility in one of the future versions of the add-on.

Natalia Sharashova (Ablebits Team) says:

Hello Yatin,

The recent upgrade of the Function by Color tool lets you process more than one color in one formula. You will still need to create separate formulas for each color, but you can then combine these formulas into a bigger one, like SUM, or COUNT(A), or AVERAGE, etc. and they will work.

Mary Trifuntova (Ablebits Team) says:

Hello Rami,
Thank you for contacting us.

Unfortunately, we do not have an add-on that can help you with your task. Sorry for not being able to help you better.

Natalia Sharashova (Ablebits Team) says:

Thank you for your question, Megan.

You can edit this formula like any other formula in Google Sheets - select the cell with it and go to the formula bar to edit it. You can easily change the range and the required sheet name. The formula will recalculate itself accordingly.
As for colors, if you're not sure of their correct RGB codes, I'd recommend using the add-on to change them.

Megan says:

Thanks so much for the quick response. Is it possible to get the box back up that is initially used to create the function to change the RGB codes, or do I need to start over? Thanks again!

Natalia Sharashova (Ablebits Team) says:

Thank you for the idea, Megan. 🙂

I've just contacted our developers with this suggestion for a discussion. They will see if it's possible to introduce such a feature.
I can't give you any timing, but I can let you know if/when it is implemented.

In the meantime, to change colors correctly, please start the tool to build a new formula.

Natalia Sharashova (Ablebits Team) says:

Hello Megan,

The recent upgrade of the Function by Color features a new option: Edit selected formula. it will help you adjust colors quickly. You can read more about it .

Mary Trifuntova (Ablebits Team) says:

Thank you for reporting this problem to us, Carlos.

For us to be able to assist you better, please send us the following details to [email protected]:
- Reproduce the issue. If you get the same error message, please send us its screenshot.
- Describe in detail what steps you follow before the issue occurs. What options do you choose on each step of the add-on? The screenshots of the steps would be very helpful.

This information will help our developer understand what is causing this problem.

Natalia Sharashova (Ablebits Team) says:

Thank you very much for your comments, Igor.

I'm afraid, there's currently an issue that has appeared recently due to some . For some reason, Google Sheets occasionally stops reading custom formulas made by other add-ons. To our regret, our Sum by Color was also affected, but flipping the ranges for calculation one way and back with our tool usually helps.

However, "ff00ff00" is an incorrect color code. If this code was returned to you by our add-on, please share an example spreadsheet with us ([email protected]) with the colors you were trying to count.

We'll check what may be causing the problem.
Thank you.

Alex says:

Igor,

I think this is the issue I'm having in my google sheet. Where/how do I find "paint format" exactly?

Thanks

Tom Arild Raen says:

Hi:)
Some of my cells are showing "0" even if its a copy paste of working cells with the exception of being a different column. At first i thought it was the copy paste that wrecked it, but it works for some columns thats the weird thing. Any idea why this is happening?