{ "subreddit": "r/googlesheets", "page": "https://redlisten.com/r/googlesheets", "updated": "2026-11-12T00:55:58.651Z", "members": 87346, "activity": { "posts_last_24_hours": 2, "posts_per_hour": 0.1, "comments_per_hour": 2.2, "newest_post_utc": 1794413408.631, "newest_comment_utc": 1794409862.089 }, "top_threads_this_week": [ { "title": "Adding time together", "score": 5, "comments": 15, "created_utc": 1794238057.838, "snippet": "I’m trying to write a spreadsheet to keep track of my shift work schedule using actual starting and finishing times (ie a timesheet). Managed to get daily hours to calculate using time formatting...", "url": "https://www.reddit.com/r/googlesheets/comments/1xrukuz/adding_time_together/" }, { "title": "Conditional Formatting for tons of different words?", "score": 4, "comments": 16, "created_utc": 1794286951.659, "snippet": "Hey, Im looking to add a Conditional Formatting rule that changes the color of a Cell if it contains specific names, but the thing is, there is like 150\\~ names to take into consideration.. I...", "url": "https://www.reddit.com/r/googlesheets/comments/1xse95k/conditional_formatting_for_tons_of_different_words/" }, { "title": "Request help combining FILTER with COUNTIF", "score": 3, "comments": 6, "created_utc": 1793946249.226, "snippet": "Link to example Goal is to set a single FILTER + COUNTIF function to count all items of Dashboard!B3:B that appear in Main Table!D2:D, but only if Main Table!A2:A has a specific value. Thanks in...", "url": "https://www.reddit.com/r/googlesheets/comments/1xp5sq0/request_help_combining_filter_with_countif/" }, { "title": "How do I make date formats to have trailing zeroes (eg. 1991-00-00)?", "score": 2, "comments": 17, "created_utc": 1794320519.773, "snippet": "Hi, everyone. I've tried to look for a similar solution online, but I'm afraid I don't know anything about formulas which is why I'm asking here. Essentially what I want to do is have dates have a...", "url": "https://www.reddit.com/r/googlesheets/comments/1xso4t9/how_do_i_make_date_formats_to_have_trailing/" }, { "title": "How do I add an image into a cell while having a functional cell inside it?", "score": 2, "comments": 26, "created_utc": 1794267491, "snippet": "I'm pretty new to Google Sheets, and I'm attempting to make a comprehensive D&D character sheet. I was going to grab assets from available online sheets I like and mesh them together while moving...", "url": "https://www.reddit.com/r/googlesheets/comments/1xs7k29/how_do_i_add_an_image_into_a_cell_while_having_a/" }, { "title": "Trying to create a Scheduling Sheet for Work", "score": 2, "comments": 6, "created_utc": 1794267064.718, "snippet": "I’m trying to set up a somewhat comprehensive sheets document to set up scheduling for employees at my job, and I want to have a field that shows how many concurrent employees are scheduled to be...", "url": "https://www.reddit.com/r/googlesheets/comments/1xs7e9g/trying_to_create_a_scheduling_sheet_for_work/" }, { "title": "Google Live Sheets Task List", "score": 2, "comments": 6, "created_utc": 1794260141.606, "snippet": "Can anyone please tell me how to get a live sheets to automatically sort a task list based on a drop down menu i've created? My drop down menu has, 4 months, 3 months, 2 months, 1 month, 2 weeks,...", "url": "https://www.reddit.com/r/googlesheets/comments/1xs4irx/google_live_sheets_task_list/" }, { "title": "Formula that changes each week", "score": 2, "comments": 6, "created_utc": 1794218061.332, "snippet": "Is there a forumla to divide a current total by how many weeks remain in a month? I'm working on a budget and would like to see how much money I could spend each week depending on what I've...", "url": "https://www.reddit.com/r/googlesheets/comments/1xrnpie/formula_that_changes_each_week/" }, { "title": "Chips for Dropdown Menu Disappeared", "score": 2, "comments": 7, "created_utc": 1794089950.47, "snippet": "I have a spreadsheet with around 200 entries. One column is a dropdown menu with seven options. I had each option color-coded, and it was possible to select more than one. This morning, each entry...", "url": "https://www.reddit.com/r/googlesheets/comments/1xqijd1/chips_for_dropdown_menu_disappeared/" }, { "title": "How can I make ArrayFormula run only when there is text in a cell when it's not a true formula?", "score": 2, "comments": 5, "created_utc": 1793994831.318, "snippet": "Hello! I have a Sheet that organizes a list of websites. 1. In one tab, the information is generated from a form people can fill out, with information like name, title, web address, etc. 2. In...", "url": "https://www.reddit.com/r/googlesheets/comments/1xpmeve/how_can_i_make_arrayformula_run_only_when_there/" } ], "newest_posts": [ { "title": "There's no dates anywhere on this spreadsheet it's entirely for tracking donations, how did we even get here?", "score": 1, "comments": 1, "created_utc": 1794413408.631, "url": "https://www.reddit.com/r/googlesheets/comments/1xtlqx2/theres_no_dates_anywhere_on_this_spreadsheet_its/" }, { "title": "Help with pivot tables. Show sales based on colors/tags.", "score": 1, "comments": 0, "created_utc": 1794401086.919, "url": "https://www.reddit.com/r/googlesheets/comments/1xtgtg0/help_with_pivot_tables_show_sales_based_on/" }, { "title": "Formula or function to display translation from two column list in multi-column categories", "score": 1, "comments": 8, "created_utc": 1794331040.305, "url": "https://www.reddit.com/r/googlesheets/comments/1xssozu/formula_or_function_to_display_translation_from/" }, { "title": "How do I make date formats to have trailing zeroes (eg. 1991-00-00)?", "score": 2, "comments": 17, "created_utc": 1794320519.773, "url": "https://www.reddit.com/r/googlesheets/comments/1xso4t9/how_do_i_make_date_formats_to_have_trailing/" }, { "title": "Conditional Formatting for tons of different words?", "score": 4, "comments": 16, "created_utc": 1794286951.659, "url": "https://www.reddit.com/r/googlesheets/comments/1xse95k/conditional_formatting_for_tons_of_different_words/" }, { "title": "How do I add an image into a cell while having a functional cell inside it?", "score": 2, "comments": 26, "created_utc": 1794267491, "url": "https://www.reddit.com/r/googlesheets/comments/1xs7k29/how_do_i_add_an_image_into_a_cell_while_having_a/" }, { "title": "Trying to create a Scheduling Sheet for Work", "score": 2, "comments": 6, "created_utc": 1794267064.718, "url": "https://www.reddit.com/r/googlesheets/comments/1xs7e9g/trying_to_create_a_scheduling_sheet_for_work/" }, { "title": "Google Live Sheets Task List", "score": 2, "comments": 6, "created_utc": 1794260141.606, "url": "https://www.reddit.com/r/googlesheets/comments/1xs4irx/google_live_sheets_task_list/" }, { "title": "Adding time together", "score": 5, "comments": 15, "created_utc": 1794238057.838, "url": "https://www.reddit.com/r/googlesheets/comments/1xrukuz/adding_time_together/" }, { "title": "Automatisch Eintrag des Datums.", "score": 0, "comments": 2, "created_utc": 1794236910.556, "url": "https://www.reddit.com/r/googlesheets/comments/1xru2x9/automatisch_eintrag_des_datums/" } ], "words_this_week": [ { "word": "cell", "titles": 16 }, { "word": "data", "titles": 14 }, { "word": "formula", "titles": 13 }, { "word": "column", "titles": 9 }, { "word": "filter", "titles": 7 }, { "word": "dropdown", "titles": 7 }, { "word": "columns", "titles": 7 }, { "word": "cells", "titles": 7 }, { "word": "conditional", "titles": 6 }, { "word": "formatting", "titles": 6 }, { "word": "create", "titles": 6 }, { "word": "list", "titles": 6 } ], "preview": "This is a preview. Every post and comment in r/googlesheets, live, as JSON or RSS on the same paths a Reddit client uses, plus keyword streams to Slack, Discord, webhook or email, needs a free key: https://app.redlisten.com/?signup=1&utm_source=redlisten&utm_medium=subreddit", "docs": "https://redlisten.com/docs", "attribution": "Source: Redlisten, https://redlisten.com/r/googlesheets" }