What r/googlesheets is talking about this week

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...

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...

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...

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...

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...

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...

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,...

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...

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...

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...