User Hassan Almaateeq

1 vote

1 answer

22 views

How to add arrayformula function to this formula with IF function?

asked Apr 19, 2021 at 20:40

1 vote

1 answer

11k views

How to combine multiple ranges with getRange in order to clear the contents of specific cells?

asked Mar 3, 2021 at 10:26

0 votes

1 answer

1k views

Can I assign two functions to a single menu item in Google sheet app script?

asked Jun 22, 2021 at 19:41

0 votes

0 answers

36 views

Is there a way to copy a tab to multiple Google-spreadsheet files at once?

asked Jun 16, 2021 at 19:32

0 votes

1 answer

224 views

Problem with query data range if a value is TRUE

asked Jun 13, 2021 at 18:33

-1 votes

1 answer

882 views

How to query data range including data formatting (color, font) in Google sheets? [duplicate]

asked May 7, 2021 at 21:19

0 votes

1 answer

4k views

How to use multiple criteria with Regexreplace in Google sheet?

asked Apr 15, 2021 at 17:18

0 votes

1 answer

75 views

How to change IFS function to switch in Google sheets? [duplicate]

asked Apr 14, 2021 at 5:29

0 votes

2 answers

33 views

How to correct this formula with If function?

asked Apr 5, 2021 at 16:44

1 vote

0 answers

15 views

How to add date criteria to query function? [duplicate]

asked Apr 5, 2021 at 14:26

0 votes

1 answer

22 views

How to sort number in the form of 00-00?

asked Feb 27, 2021 at 19:12

-1 votes

1 answer

694 views

How to combine ranges of getRange in one variable in Google sheets? [duplicate]

asked Mar 19, 2021 at 20:55

1 vote

1 answer

200 views

Is there a way to make Google Sheet files as static data values or export to cloud databases?

asked Mar 12, 2021 at 19:48

0 votes

1 answer

27 views

How to sum range of values if date =specific date but keep result fixed next day?

asked Mar 6, 2021 at 9:38

0 votes

1 answer

319 views

How to reference named range as sheet name in query function?

asked Mar 8, 2021 at 7:34

0 votes

2 answers

929 views

How to make the cells of query function results with borders that are dynamic according to rows/column numbers?

asked Mar 2, 2021 at 20:14

0 votes

1 answer

392 views

How to overwrite or change the value of a cell that has the results of query function if it meets a new criteria?

asked Feb 5, 2021 at 6:11

0 votes

1 answer

748 views

How to use query with a criteria where Col1 is equal to a value in a cell?

asked Feb 5, 2021 at 8:39

2 votes

1 answer

40 views

How to solve the issue of sorting numbers in 00-00 format?

asked Feb 28, 2021 at 7:37

0 votes

1 answer

28 views

How to convert a rational number like 1.6 to the higher integer number?

asked Feb 28, 2021 at 13:29

0 votes

1 answer

236 views

How to apply a conditional formatting rule on the last row of similar cell value across one column?

asked Feb 26, 2021 at 17:51

1 vote

1 answer

58 views

Making dynamic number of arguments based on a specific criteria for importrange function

asked Feb 24, 2021 at 20:35

0 votes

1 answer

664 views

How to refer to a cell value within importrange function?

asked Feb 18, 2021 at 12:07

1 vote

1 answer

2k views

How to clear range instead of sheet in Google script?

asked Feb 19, 2021 at 7:37

1 vote

1 answer

137 views

How to automatically fill, sort and conditionally format 1st day of the week according to given year and month

asked Feb 19, 2021 at 19:28

0 votes

2 answers

63 views

How to sort a column with date that is impeded within Texts?

asked Feb 18, 2021 at 9:24

1 vote

1 answer

60 views

Problem with results of filter function from tabs that have no data yet

asked Feb 19, 2021 at 12:18

1 vote

1 answer

36 views

How to express the "*" denoting any text containing part of text when using IF function?

asked Feb 15, 2021 at 2:48

1 vote

1 answer

100 views

How to combine these formulas in one conditional formatting rule

asked Feb 9, 2021 at 21:07

0 votes

1 answer

43 views

How to check if a cell is empty if it contains a reference value?

asked Feb 5, 2021 at 0:36

Stack Exchange Network

41 Questions

How to add arrayformula function to this formula with IF function?

How to combine multiple ranges with getRange in order to clear the contents of specific cells?

Can I assign two functions to a single menu item in Google sheet app script?

Is there a way to copy a tab to multiple Google-spreadsheet files at once?

Problem with query data range if a value is TRUE

How to query data range including data formatting (color, font) in Google sheets? [duplicate]

How to use multiple criteria with Regexreplace in Google sheet?

How to change IFS function to switch in Google sheets? [duplicate]

How to correct this formula with If function?

How to add date criteria to query function? [duplicate]

How to sort number in the form of 00-00?

How to combine ranges of getRange in one variable in Google sheets? [duplicate]

Is there a way to make Google Sheet files as static data values or export to cloud databases?

How to sum range of values if date =specific date but keep result fixed next day?

How to reference named range as sheet name in query function?

How to make the cells of query function results with borders that are dynamic according to rows/column numbers?

How to overwrite or change the value of a cell that has the results of query function if it meets a new criteria?

How to use query with a criteria where Col1 is equal to a value in a cell?

How to solve the issue of sorting numbers in 00-00 format?

How to convert a rational number like 1.6 to the higher integer number?

How to apply a conditional formatting rule on the last row of similar cell value across one column?

Making dynamic number of arguments based on a specific criteria for importrange function

How to refer to a cell value within importrange function?

How to clear range instead of sheet in Google script?

How to automatically fill, sort and conditionally format 1st day of the week according to given year and month

How to sort a column with date that is impeded within Texts?

Problem with results of filter function from tabs that have no data yet

How to express the "*" denoting any text containing part of text when using IF function?

How to combine these formulas in one conditional formatting rule

How to check if a cell is empty if it contains a reference value?