google sheet

I'm currently working on creating an income and expense tracker that covers 12 months within a single Google Sheets spreadsheet. I need a feature that allows me to select any month and automatically compile all the income and expense details, along with their respective totals for that...

I'm looking for a formula that will help me return the merged cell value for every question that is next to a particular merged cell. See image below. I have huge sets of questions and areas sheets that I get sent. And just looking to use formula to help me arrange the data the way I need Thanks

We have 2 sheets (Sheet 1) and (Sheet 2). sheets1 has 3 columns (Title1) - (Size1) - (Stock1). sheets2 has 3 columns (Title2) - (Size2) - (Stock2). We want to update each cell in (Stock2) Column in (Sheet 2) when any cell in Title1 and size1 in sheet1 = any cell in Title2 and And Size2...

Hello everyone! I have a database in Google Sheets of materials (leather, steel, etc..) that have different modifiers (100%, 70%, etc...). This creates a curve that interpolates between the points. My issue is that in Master!D:D I wrote the following formula: =IF(E3<0...

Hi all, I've been struggling with a formula for GSheets. I have the data in another sheet and I want to count how many time does a name appear during 7 columns. Any help is greatly appreciated,

Google Forms saves responses to a Google Sheet, which can be accessed live. Microsoft Forms clearly saves responses somewhere, but I can't seem to access the Office 365 equivalent of the live Google Sheet attached to the form. The "See in Excel" link basically exports current results into an...

Hello everyone, I am sharing this shared sheet with you in order to find a function/script to add as follow: Whenever a user makes a change in the column J, his email/name will be written in relative column K. here's the google sheet MySheet

Hi, Can someone please help achieve the same result as the one shown in the expected output format: https://docs.google.com/spreadsheets/d/1C1ywcjsmAksVlXZY4NNNjudnagZ1klSaU5iYgPLLXBs/edit#gid=0 What can i add to the formula in C5 to make that happen? Thanks alot, Lin

Hi, I am using a simple google sheet that lets me schedule calls to clients after x number of days from a start date. Some dates fall on the weekends and I was wondering if there is a way for the date to adjust automatically to avoid a weekend. If the date falls on a Saturday, it would be...

I'm wondering how to use the sort and filter function in Google sheets to sort in ascending order the following: 1-2 months 2-3 months 3-4 months ...up to 11-12 months Right now when I sort 1-2months comes first, followed by 11-12 months. Is there a simple way to sort these fields according...

I have a question about what formula I should use for the following: I have a spreadsheet (similar to below). Across the columns are values such as A, B, C etc. Down the rows are item numbers. I have one table which has these items down the rows and ticks next to the relevant column value. E.g...

Hello, Actually I have to update a master google excel sheet daily with numeric values. There are thousands of names across which value to be updated daily by datewise (new date in new column). Daily I get names with num values which eventually to be entered in their respective cell of a new...

What formula would I use in Google Sheets to insert a check box into cell A2 if the value of cell B2 is "Signing"? I only need the check box if B2 is signing I can get column A to have all check boxes or add them in individually but there has to be automated way to do this. Maybe with a...

I am trying to use the filer formula to get data from a Google form response in Google Sheets what I am using is =Filter('Form Responses 1'!B2:U,'Form Responses 1'!B2:B="Original","Follow Up") It does not work it does work if I omit the ,"Follow Up" but it does not give me all the data I...

Hello, I have a work item where I’m in need to mark or categorize the shift data based on times ! Say for eg : 6 AM - 01-30 PM = Morning shift 01.30 PM - 09.30 PM = Noon shift 09.30 PM - 06 AM = Night shift My input data in A column would be 00:57 AM 13:47 PM

Hello everyone, After getting inspired by such an amazing community, I have also decided to create a blog in 2022 to share my knowledge and learning. I am basically good at Google Workspace software such as Google Sheets, Docs, and Slide. I have booked two domains "OfficStacks.com" (which...

Hello guys, I have a job that has to do with Google Sheets and would love to get your support in the MrExcel community I have a sheet like this. Phone API URL Access_Token_from_API_URL 09199999999...

Couldn't find a forum on this site for google sheets, so posting in here instead. I am trying to create a cashflow forecast, using an if formula to test what the day of the month is, and use this to allocate a particular cost/revenue to a column relative to that week. Basically: If (day of...

I have three columns in which I want sum value of col3 based on col1 and col2 value if col1 = 1 and col2 = 40 then sum all value of col3 but if col1 = 1 and col2 = 20 or col1 = 2 and col2 = 40 then sum col3 value according to the col1 and col2 value for this purpose I am sharing the link of...

Hello everyone, I need your help. I have a table of employees. I want to provide an alternative in case there is a clash with dates or amount of hours worked. I managed to get a formula that goes through my list of employees but it only goes through once. I want it to start over if there is no...