Skip to main content
Hassan Almaateeq's user avatar
Hassan Almaateeq's user avatar
Hassan Almaateeq's user avatar
Hassan Almaateeq
  • Member for 5 years, 7 months
  • Last seen more than a month ago
1 vote
1 answer
25 views

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

1 vote
1 answer
13k views

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

0 votes
1 answer
1k views

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

0 votes
0 answers
43 views

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

0 votes
1 answer
275 views

Problem with query data range if a value is TRUE

-1 votes
1 answer
1k views

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

0 votes
1 answer
5k views

How to use multiple criteria with Regexreplace in Google sheet?

0 votes
1 answer
88 views

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

0 votes
2 answers
33 views

How to correct this formula with If function?

1 vote
0 answers
15 views

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

0 votes
1 answer
26 views

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

-1 votes
1 answer
877 views

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

1 vote
1 answer
269 views

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

0 votes
1 answer
31 views

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

0 votes
1 answer
370 views

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

0 votes
2 answers
1k views

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

0 votes
1 answer
525 views

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

0 votes
1 answer
960 views

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

2 votes
1 answer
45 views

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

0 votes
1 answer
31 views

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

0 votes
1 answer
291 views

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

1 vote
1 answer
65 views

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

0 votes
1 answer
847 views

How to refer to a cell value within importrange function?

1 vote
1 answer
2k views

How to clear range instead of sheet in Google script?

1 vote
1 answer
153 views

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

0 votes
2 answers
69 views

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

1 vote
1 answer
67 views

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

1 vote
1 answer
38 views

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

1 vote
1 answer
106 views

How to combine these formulas in one conditional formatting rule

0 votes
1 answer
44 views

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