Power Tools provides you with a set of add-ins to speed up most of your daily tasks in Google Sheets. Shuffle is one of those utilities. It will help you randomize cells, rows, and columns in your Google spreadsheet.
The Shuffle tool also processes cells in filtered & hidden rows & columns.
You can choose one of five ways to sort values at random:
Once the shuffling mode is selected, click on the Shuffle button to randomize values within the selected range.
I need assistance related to utilizing power tools which I activated already.
Still, the error message appears.
We apologize for the inconvenience caused by our add-on. Please contact us by email, email@example.com, and specify which feature of the Shuffle tool you were using when the error happened? It would be helpful if you could attach some screenshots of the error message and the settings you chose in the tool.
Can the shuffler works with some specific rules and shuffle the entire rows automatically whenever it see the order to be shuffled.
Thank you for your question.
The Shuffle tool cannot process data automatically. You need to run the tool each time you want to shuffle rows.
I dont have power tools option? Is it changed? I dont have any other way.
Thank you for your comment.
Could you please describe in more detail the problem you've faced? Any screenshots illustrating the issue would help a lot. Please send the details to firstname.lastname@example.org.
We'll try to help. Thank you.
After using the shuffle tool on rows which have cells including dates
When trying to copy to another sheet they dates come up as numbers etc
as opposed to
23 Dec 2016
02 Feb 2015
07 Dec 2011
Is there any way to fix this?
Only seems to be an issue when I have used power tolls to shuffle
Thank you for contacting us. For us to be able to help you better, please share a sample spreadsheet with your source data with us (email@example.com) so we might reproduce this issue on our side. When sharing, make sure the option 'Notify people' is checked. To grant us access to your data, press the Share button at the upper right corner of Google Sheets and enter firstname.lastname@example.org.
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 in this message thread.
If you have confidential information there, you can replace it with some irrelevant data, just keep the format.
We'll do our best to help.
Can this be done via mobile? When I do click add-ons it gives me 6 other apps to in-store but don't tell me what I actually need.
Thank you for your question. Please note that our add-ons were designed to work in the desktop browsers (Chrome, Firefox, Safari on a Mac). If you open Google Sheets in a mobile browser, we can't guarantee that our add-ons will work there since we do not support mobile platforms.
Thanks for the power tools tutorial. Worked perfect for me.
Thank you for your lovely feedback, Jude! :)
Is there a way to use the randomizes with rules? I am trying to shuffle our team’s schedule. One member of our team will always have a higher probability of being placed as she has six combinations but I don’t want her to be place too many times in a row.
Thank you for your question. Sorry, but our Shuffle tool randomizes your data in a totally random way. It is not possible to set any rules or priorities in the current version of the add-on.
i have 4 cells in 2 rows like this:
[player x] 
[player y] 
the first row have a red background and the second row have a yellow background.
I want to switch between the two rows *including* their background so i will look like this:
[player y]  (with yellow background)
[player x]  (with red background)
help me please!! thank you
I'm sorry, the add-on can process only values at the moment. We are currently working on fixing this for one of the next versions, but I can't give you any timing.
If you'd like, we can let you know when the feature is available.
Post a comment
Seen by everyone, do not publish license keys and sensitive personal info!