Hi! Is there a way to set up trigger so that the scenario would run automatically every time that the data has been altered? Thank you in advance.
Thank you for your question. I'm afraid it's currently impossible to process data with our tools or scenarios automatically. You need to run it each time you want to do that.
However, I have forwarded your idea to our developers to see if they could implement it. Thank you.
Need to find duplicates in multiple (six) sheets within a spreadsheet but I can only choose between two.
Plus, would be great if could make the duplicate conditional. i.e.: color duplicate in sheet 1 if appears in (at least) 3 of the 6 sheets.
Realise it's a bit complex, but would go a long way.
Any way to do that?
Thank you for your comment.
Unfortunately, the current version of Compare Columns or Sheets can work only with two sheets at a time. You need to run the add-on several times to process more sheets.
However, there are scenarios available in the add-on. You can save the settings you use most often and give this set a name – this is your scenario. Once you run it, your sheet will be processed right away, and you won't need to go over the same steps again. You can view, edit, and delete scenarios quickly anytime. Please see how to work with scenarios here.
I will also forward your request to our developers and they will look into the possibility to improve the add-on functionality. Thank you.
i have 1 sheet employee with foto from google drive
i have 1 sheet up to date called employee new.
how can i sync the employee with the employee new ?
all data is in rows:
a1 name a2 number a3 date of birth etc (both sheets same)
so i want the not active personel out and new added below
can this be done?
greetz from Holland
Thank you for contacting us. If I understand your task correctly, our Merge Sheets may help you solve it. It allows you to update the data in the main table with the data from the lookup table based on the key column(s). You can install it from Google Workspace Marketplace and test it out for 30 days for free to see if it suits your needs.
However, it'll replace the non-active users with the new ones only if they have some matching criteria (for example, if their IDs are identical). Otherwise, you'll need to manually remove the old employees. Please also check the detailed instructions on how to use Merge Sheets on this help page: https://www.ablebits.com/docs/google-sheets-merge-two-sheets/
Hope you'll find our add-on helpful. Let us know if you have any further questions or need some assistance.
how can I use your addon to compare sheets within 2 different google sheet files?
Thank you for your question. Sorry, the add-on works within one spreadsheet only.
Since the tool lets you compare data within one file, you may consider bringing everything together before comparing. We have a special add-on for that as well – Combine Sheets. Here's a tutorial page in case you're interested.
This add-on doesn't seem to work consistently.
Example: I'm trying to compare two worksheets. When comparing by 'entire worksheets' it reports no duplicates found (I've ensured the correct columns are matching). However, when I choose one column at a time and compare the worksheets it will find duplicates...
This is frustrating as there are numerous columns I'm trying to compare. The only workaround I have is querying one column at a time, which defeats the purpose of this tool.
Is there a solution for this?
I've just replied to you by email. Please provide us with the information requested in the email message. Thank you.
I just purchased your product but it doesn't reflect on my google sheets.
Kindly help asap.
Buenos días, quisiera que el proceso de ver los datos únicos, se automatizará, en vez de realizarlo de forma manual, como puedo programarlo????
I'm afraid that it's impossible to run our add-on automatically, but recently we've introduced scenarios for our Remove Duplicates that can help you automate repetitive tasks and check for duplicates in a click. Just save the settings you use most often and give this set a name – this is your scenario. Once you run it, your sheet will be processed right away, and you won't need to go over the same steps again. You can view, edit, and delete scenarios quickly anytime.
Feel free to check the detailed instructions on how to work with scenarios on this help page.
If you encounter any difficulties or need our assistance, please let us know. We'll do our best to help.
Post a comment
Seen by everyone, do not publish license keys and sensitive personal info!