I have a Google spreadsheet that has 20 sheets
there is a Google table. there are 20 sheets in it. I need each user to have access to a specific sheet, for example, for a user [email protected] there was access to sheet 2 , and the rest of the sheets were blocked for it, as well as for the user [email protected] there was only access to the sheet 3
Sparkline and progress bar
I am trying to create a progress bar based on the number of checkboxes checked:
https://docs.google.com/spreadsheets/d/1MBw_W6kA2qNQaW5t1WZGuOMYpQkYlCkyTlDZ0yLCrdU/edit?usp=sharing
Create a custom formula for conditional formatting that compares values in 4 columns to determine if they are a % higher than the original value
I am working with a dataset where participants were tested on a performance measure at various periods of time. When cleaning the data, we are looking to ensure that a more technical formula set up by the team upstream is properly capturing all cases where the participant improved on their original score by 26% or more.
In the same Google Sheet Workbook, can you extract the info from a cell in Sheet A to a cell in Sheet B, and link it back to the same cell in Sheet A?
I am trying to do a tracking excel workbook on Google Sheets that has a Masterlist in Sheet A, and a person’s result tracking on Sheet B.
Sheets countifs function returning 0 value
I’m trying to work on a google sheets page and count all specific values in a column that are either a 1 or 2 value. I’m basically condensing a survey with a 1-10 range of agreement with questions down to 1-5, “strongly disagree”, “mildly disagree”, et cetera to rotate those answers to a pivot table and make some pie charts representing the different questions answers.
Countif count Sunday to Friday correctly until it reach Saturday in google sheets
I have 14 dates which only 1 fall on a Saturday. I like to count that Saturday and use it in another formula.
Trying to create a dynamic report but Stuck on a QUERY function
Thank you in advance. I’m very new to this type of programming (using query).
Copy entire sheet and append to another one
How can I copy an entire sheet tab and append it (below the last existing row) to another sheet inside the same Google Sheets document. The structure of those two sheet tabs are the same.
How can I match a smart chip using SUMIF?
I have a column of people smart chips in a spreadsheet, and I want to use them in the range of a SUMIF, but I can’t get them to match any value I provide as the criterion. I’ve tried the string value of the chip (e.g. "John Doe"), and I’ve tried the corresponding email address (e.g. "[email protected]"), but I can’t get anything to match the smart chip. The only thing that has worked is referencing a cell that contains a smart chip. How can I match a smart chip for the purposes of functions like EQ, COUNTIF, and SUMIF?
Mark a data validation dropdown criteria as done, if a certain value is in another cell?
I have a work sheet, and I am using data validation dropdown options to track the progress of the workflow. I have a certain section of that workflow that is only needed when the job is for a specific project. The data validation options are “Done” “In progress” and “Not started”. Is there a way to make it so that when, say for example, cell E 26 has the value of “FALSE”, the data validation dropdown options in the cells E10:E14 are automatically set as Done.
Example sheet will show how I have it set right now, and the “Result” sheet will show what I would like it to look like:
https://docs.google.com/spreadsheets/d/1Y_mbGtw4uDbCi0qWSfpmlwnhJ-Zo706bmetswj694gc/edit?usp=sharing