google sheet

  1. J

    How to filter and sort according to a preset order in Google Sheets

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

    Formula to find column value with ticked/filled cells for Google Sheets

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

    how to replace a cell num value with another cell num value by using a formula?

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

    Insert Check Box in Google sheets based on value of another cell

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

    Import data from one Google Sheet to another Sheet with in the same document using 2 criteria

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

    Categorize shifts based on time

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

    Need a Quick Suggestion from the Community!

    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 "" (which...
  8. H

    Google Sheet function pull access_token in API

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

    Google sheets help - If formula with date issue.

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

    Sum value col3 based on value of col1 and col2 for Google Sheets

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

    Value from list depending on conditions that should start over once finished

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

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back