Google Sheets Community

Contact owners and managers

1–30 of 86

Welcome to the public Google Sheets Community!

Please use this group to post questions, seek advice, or share your Sheets experience.

Before asking a new question, please visit the Sheets Documentation and this group's past questions.

Your email may be visible to members who subscribe to posts by email.
If someone contacts you privately, and you want feedback about the person who contacted you, please contact a group moderator.
To inquire about hiring a developer, post a basic description of your requirements.
If you are a freelancer looking for work, consider a site like: www.upwork.com or Automation and work [facebook]
It is considered a good practice to ask a person if they can be contacted privately before doing so.
If you post links, or attachments your post may be held for review.

This is an unofficial fan group!

0 selected

Apr 27

Search string/word in Google sheets

Hi all ! I would like to search words in a cell and return the word found. ie my cell contains "

unread,

Search string/word in Google sheets

Hi all ! I would like to search words in a cell and return the word found. ie my cell contains "

Apr 27

Apr 14

Conditional formatting "Before today" in another cell

see "perla" tab On Sunday, April 14, 2024 at 6:40:10 AM UTC-7 Jacob Chavez wrote:

unread,

Conditional formatting "Before today" in another cell

see "perla" tab On Sunday, April 14, 2024 at 6:40:10 AM UTC-7 Jacob Chavez wrote:

Apr 14

Apr 8

index and Match formula for a contingency table

https://docs.google.com/spreadsheets/d/1BoXpwCCRCPEapWcChRVZ571aG1B59c7ZawtWVOkUz2c/edit?usp=sharing

unread,

index and Match formula for a contingency table

https://docs.google.com/spreadsheets/d/1BoXpwCCRCPEapWcChRVZ571aG1B59c7ZawtWVOkUz2c/edit?usp=sharing

Apr 8

SmartWebCare IT Solutions (SmartWebCare), Zuccaro2

Mar 30

Solution for Warning "This file looks suspicious" in Google Sheet

Hello, Google Sheets does not offer a way to identify which hyperlinks are "suspicious."

unread,

Solution for Warning "This file looks suspicious" in Google Sheet

Hello, Google Sheets does not offer a way to identify which hyperlinks are "suspicious."

Mar 30

Francesco Ranieri, Zuccaro2

Mar 28

exclude a range in a column from the duplicate count

Hello Francesco, Try using the formula =COUNTUNIQUE(B5:B67). Thank you, Zuccaro The information

unread,

exclude a range in a column from the duplicate count

Hello Francesco, Try using the formula =COUNTUNIQUE(B5:B67). Thank you, Zuccaro The information

Mar 28

Chava, Zuccaro2

Mar 28

Conditional formatting based on linked cell value

Hello Chava, Try using the formula =IF(A1:A6,A1)>3 within the conditional format rules. See the

unread,

Conditional formatting based on linked cell value

Hello Chava, Try using the formula =IF(A1:A6,A1)>3 within the conditional format rules. See the

Mar 28

Mathew Lewis, Chava2

Mar 28

Search Different Worksheets Using Different Criteria

You could do it with VLOOKUP but I think it'd be neater with the QUERY. https://infoinspired.com/

unread,

Search Different Worksheets Using Different Criteria

You could do it with VLOOKUP but I think it'd be neater with the QUERY. https://infoinspired.com/

Mar 28

Chasing White Lines, Chava2

Mar 28

Vlookup function doesn't recognize values with a dash

Sounds like a data type issue, have you tried changing the data type to string? https://

unread,

Vlookup function doesn't recognize values with a dash

Sounds like a data type issue, have you tried changing the data type to string? https://

Mar 28

Mar 25

Lookup formula issue

Hello, i have got some issue with the =LOOKUP formula, it doesn't return the correct result.

unread,

Lookup formula issue

Hello, i have got some issue with the =LOOKUP formula, it doesn't return the correct result.

Mar 25

Mar 18

Need to add an OR argument to an AND statement within formula

I answered my own question and came up with: =IF(AND(OR(I42=1, I42="CB"), U42=2)=TRUE, J42*

unread,

Need to add an OR argument to an AND statement within formula

I answered my own question and came up with: =IF(AND(OR(I42=1, I42="CB"), U42=2)=TRUE, J42*

Mar 18

Mar 13

Rolling Average of lowest 8 of recent 10 scores posted

Hi, I am trying to find a formula that is able to create the average of the lowest 8 scores of the

unread,

Rolling Average of lowest 8 of recent 10 scores posted

Hi, I am trying to find a formula that is able to create the average of the lowest 8 scores of the

Mar 13

Mar 11

fill a specific range if a cell contains E

Hello, I am looking for a solution, need a formula that fills the cel around the Cell with the E (F15

unread,

fill a specific range if a cell contains E

Hello, I am looking for a solution, need a formula that fills the cel around the Cell with the E (F15

Mar 11

Reyhan Assany, Diego Ravecca3

Mar 10

Indexing specific data form Range number

nested IF formula =IF(AND(A2>=$F$2;A2<=$G$2);$H$2;IF(AND(A2>=$F$3;A2<=$G$3);$H$3;IF(AND(

unread,

Indexing specific data form Range number

nested IF formula =IF(AND(A2>=$F$2;A2<=$G$2);$H$2;IF(AND(A2>=$F$3;A2<=$G$3);$H$3;IF(AND(

Mar 10

Sara _ Learning, Diego Ravecca2

Mar 8

Automatic Timesheet _ going crazy with Logic

Hi, Let me know if this is correct line 4 -> =IF(B3<=7.5,B3,7.5) line 5 -> =IF(AND(B3>7.5

unread,

Automatic Timesheet _ going crazy with Logic

Hi, Let me know if this is correct line 4 -> =IF(B3<=7.5,B3,7.5) line 5 -> =IF(AND(B3>7.5

Mar 8

Laura O'Brien, … Diego Ravecca3

Mar 5

Using formatting in a formula

Alexander is right. I think best option is to have a helper column where you record the state, lets

unread,

Using formatting in a formula

Alexander is right. I think best option is to have a helper column where you record the state, lets

Mar 5

Kyle Wilson, … Diego Ravecca3

Mar 5

Data input help

Hi, probably you need to store the data in array format but you are iterating inside array. Best El

unread,

Data input help

Hi, probably you need to store the data in array format but you are iterating inside array. Best El

Mar 5

Harold Weaver, Reyhan Assany2

Mar 3

Conditional Formatting if date is beyond so many days out

Hi, in my case I use the new column that contains the calculation for each date first. I name it the

unread,

Conditional Formatting if date is beyond so many days out

Hi, in my case I use the new column that contains the calculation for each date first. I name it the

Mar 3

Feb 21

Hi all, I need to group by rows a large table (> 20.000 rows). In Apple Numbers, I do this by

unread,

Hi all, I need to group by rows a large table (> 20.000 rows). In Apple Numbers, I do this by

Feb 21

Asad Khalid Yousuf

Feb 19

Sheets App in Android very frustrating

The android sheets app (not sure if the same on Iphone) is just unable to work with big sheets (10000

unread,

Sheets App in Android very frustrating

The android sheets app (not sure if the same on Iphone) is just unable to work with big sheets (10000

Feb 19

Feb 15

thanks Keith for your help. I found what was causing the issue, that needed permission when run for

unread,

thanks Keith for your help. I found what was causing the issue, that needed permission when run for

Feb 15

Harold Weaver, Zuccaro3

Feb 13

If a range is less than a certain number, display a specific number?

I meant to thank you, this was exactly what I needed. I really appreciate it. (I just posted another

unread,

If a range is less than a certain number, display a specific number?

I meant to thank you, this was exactly what I needed. I really appreciate it. (I just posted another

Feb 13

Pete Altman, Zuccaro2

Feb 7

Sheets is formatting my cell in response to specific text entry

Hello Pete, Is it possible for me to please see a screenshot on the problem. Thank you, Zuccaro On

unread,

Sheets is formatting my cell in response to specific text entry

Hello Pete, Is it possible for me to please see a screenshot on the problem. Thank you, Zuccaro On

Feb 7

Butch Hinton, Zuccaro2

Feb 7

Array formula no longer working

Hello Butch, The numbers you are seeing is the digital representation of dates. To change from

unread,

Array formula no longer working

Hello Butch, The numbers you are seeing is the digital representation of dates. To change from

Feb 7

Jan 31

Chrome Captures ALT Keypress

Interesting development: I discovered that it is still possible to open the Sheets menus, but the

unread,

Chrome Captures ALT Keypress

Interesting development: I discovered that it is still possible to open the Sheets menus, but the

Jan 31

Jan 31

Issue with Google Sheets Script: Incomplete Data Entry for New Records

and it is also not possible to make changes of the empty rows - deleting is also not possible. Tulga

unread,

Issue with Google Sheets Script: Incomplete Data Entry for New Records

and it is also not possible to make changes of the empty rows - deleting is also not possible. Tulga

Jan 31

Jan 26

If Statement error

Many thanks for taking the time to reply to my query. I was aware that the date was a text and I made

unread,

If Statement error

Many thanks for taking the time to reply to my query. I was aware that the date was a text and I made

Jan 26

Jan 25

When I submit a response it creates a new tab (sheet) instead of recording in the FORM RESPONSES.

I have a spreadsheet "Master Budgeting Template", that contains a sheet "FORM

unread,

When I submit a response it creates a new tab (sheet) instead of recording in the FORM RESPONSES.

I have a spreadsheet "Master Budgeting Template", that contains a sheet "FORM

Jan 25

Louie Carratt, Swarup Modak3

Jan 23

Updated rows go DIRECTLY above the header row

absolutely, here it is: https://docs.google.com/spreadsheets/d/1VsNQAJ9R4UYeQini-

unread,

Updated rows go DIRECTLY above the header row

absolutely, here it is: https://docs.google.com/spreadsheets/d/1VsNQAJ9R4UYeQini-

Jan 23

Harold Weaver, Swarup Modak2

Jan 21

SUMIFS and COUNTIFS formula help

Hi Harold, Could you please prepare a sheet and share the link for clear understanding of the issue /

unread,

SUMIFS and COUNTIFS formula help

Hi Harold, Could you please prepare a sheet and share the link for clear understanding of the issue /

Jan 21

stephen silk, Swarup Modak2

Jan 19

googlefinance syntax

Hi Stephen, Could you please check the below? QUERY(GOOGLEFINANCE("GOOGL", "open"

unread,

googlefinance syntax

Hi Stephen, Could you please check the below? QUERY(GOOGLEFINANCE("GOOGL", "open"

Jan 19

Search

Clear search

Close search

Google apps

Main menu