Title: Filter Google Sheet
Last modified: April 7, 2022

---

# Filter Google Sheet

 *  Resolved [GMRobbins](https://wordpress.org/support/users/gmrobbins/)
 * (@gmrobbins)
 * [4 years, 2 months ago](https://wordpress.org/support/topic/filter-google-sheet/)
 * I have a sheet of players with game statistics. I want to display via NinjaTables
   all records with more than 3 games played. Something like: if “games” >3, then
   display records. Any players with less than 4 games are not displayed.
 * I have tried various shortcodes with no luck.

Viewing 1 replies (of 1 total)

 *  Plugin Support [Syed Numan](https://wordpress.org/support/users/annuman/)
 * (@annuman)
 * [4 years, 1 month ago](https://wordpress.org/support/topic/filter-google-sheet/#post-15554439)
 * Hello [@gmrobbins](https://wordpress.org/support/users/gmrobbins/),
 * Using Advanced Shortcode, this is relatively easy to do, but first, you will 
   have to configure the Game column data type as Numeric Value. Then use the shortcode
   on the page to display only rows that contain greater than 3 values in the Game
   column cell.
 * `[ninja_tables id="your table ID" filter="{gt}3" filter_column='game column's
   column key']`
 * Thank You

Viewing 1 replies (of 1 total)

The topic ‘Filter Google Sheet’ is closed to new replies.

 * ![](https://ps.w.org/ninja-tables/assets/icon-256x256.png?rev=3337819)
 * [Ninja Tables – Easy Data Table Builder](https://wordpress.org/plugins/ninja-tables/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/ninja-tables/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/ninja-tables/)
 * [Active Topics](https://wordpress.org/support/plugin/ninja-tables/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/ninja-tables/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/ninja-tables/reviews/)

 * 1 reply
 * 2 participants
 * Last reply from: [Syed Numan](https://wordpress.org/support/users/annuman/)
 * Last activity: [4 years, 1 month ago](https://wordpress.org/support/topic/filter-google-sheet/#post-15554439)
 * Status: resolved