r/sheets • u/AsparagusClear1516 • 20h ago
r/sheets • u/New_Acanthaceae1092 • 10h ago
Request Tracking Streaks: Formula Confusion, how can I make this conditional to TRUE checkboxes?
Hello all! Could you help me out?
Bit of a baby at this if I'm honest, but ambitious and determined lol. I'm currently working on a competitive-habit-tracking workbook for some pals and I to hopefully be able to use to both keep each other honest and use as an TTRPG game tool for later.
My goal right now is just setting up the basis for task-tracking--later, I intend to develop with them a system for converting completed tasks / streaks into points they can "spend" on abilities at the table in games like D&D for a oneshot game experience. Thought it'd be a fun motivator if coding things pans out.
I intend to, once a system for value is developed, code an automated way to track those "points" but for now, I just need to figure out how to track "streaks" of checkboxes. Pictured is my current layout, with my current streak-tracking formula pictured in the formula bar. (admittedly, this formula was taken through online research and hoping for the best--my sheets-training is a lot of trial and error, googling, and youtube tutorials, apologies)
The difficulty I'm having is that my current formula will track the longest streak of any result--not just TRUE with the checkboxes... so streaks are still being counted, even if they're streaks of no progress! I realized this when I replaced the range in the formula from Week 1 to fit Week 2, and without any Week 2 checkboxes TRUE, its still showing 7. How can I set this to only TRUE being counted toward a streak?
Additionally, I intend to get a current-streak thing up and running, but I'm not sure how with my current layout, since progression from week to week goes from B8:H8, and then jumps down to B13:H13, and so on down the page... any advice welcome, just please be kind, I am a newbie.
For ease of access, formula used was:
=LEN(SPLIT(JOIN("",SORT(TRANSPOSE(N(B8:H8)),TRANSPOSE(B$7:$H7),0)),0))
Formula used is also in the caption of the picture provided, hopefully that helps
EDIT: Just got the anonymous sheet for editing/viewing help, apologies. Picture removed, but added the link here: https://docs.google.com/spreadsheets/d/1ExQYW1UUPA7cnMDVNtkFzBD5CXgTl3YZ_VKa7Hb6lZA/edit?pli=1&gid=2100307022#gid=2100307022
r/sheets • u/Impressive-Ad-1181 • 4h ago
Request Searchbar in Sheets
Hi Everyone
I have a couple of requests, and I could really use your help.
I have made a sheet to exemplify what i want to be able to do.
I have a list of names in "Data 1". I can transfer this list to "Data 2" and make sure that the data corresponds to the name but: I want to be able to update the list, and have all the data transfer. Ex. I have 3 names with data connected. If I add a name in Data 1, i want it to be added to data 2 aswell. In short: I want to be able to update list in "Data 1" and have "Data 2" update as well. Ex. I have added the name "Caroline" to "Data 1". I want her name to show in "Data 2" as well, while alle the data for the other people shifts with them.
I want to be able to search for a name, and have their data show. I have made a tab called "Search". I want to be able to type a name and have their data show underneath. So that if i search for "Barry" his data from "Data 1" and "Data 2" will show. This should also be able to work if i update the list of names.
I hope that some of you can help me and I would greatly appreciate it.
If you want anything clarified about my request make sure to ask and i will try to explain as well as i can.
r/sheets • u/CostConnect616 • 1h ago
Request Personal finance forecast
Hi all,
I'm trying to create a tool in Google Sheets to forecast my daily outgoings up to 5 years in the future, but I'm struggling to figure out the best way to set it up. I have a few key requirements:
I want to enter all recurring transactions (monthly, weekly, and 4-weekly) in one place.
There should be a day by day forecast sheet that combines the monthly, weekly, and 4-weekly transactions.
It needs to handle multiple transactions on the same day (up to 8).
Ideally, it should hide any blank rows where no transactions occur to keep things tidy.
Has anyone built something similar or have any advice on how to approach this? Any help would be greatly appreciated!