Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.

Sign up to join this community

Anybody can ask a question

Anybody can answer

The best answers are voted up and rise to the top

Explore our Questions

Ask Question

more tags

Active 1 Bountied Hot Week Month

18

votes

2

answers

9k

views

Short number format in Google Sheets; 1,024 → 1K, 1,816,724 → 1.8M

google-sheets formulas formatting

modified 11 hours ago jm3 285

1

vote

1

answer

23

views

Conditional Formatting Duplicate Invoices in Google Sheets

google-sheets formulas conditional-formatting

modified 14 hours ago Community♦ 1

0

votes

1

answer

26

views

Import and SUM chosen (from drop-down) column to Sheet1 from Sheet2

google-sheets formulas google-sheets-query google-sheets-arrayformula import

modified 16 hours ago Community♦ 1

0

votes

1

answer

244

views

Max value conditional formatting rule not working in Google Sheets

google-sheets formulas conditional-formatting

modified yesterday Community♦ 1

-1

votes

1

answer

37

views

Inaccurate output when using importrange vs manual input

google-sheets formulas importrange regexextract

modified yesterday Community♦ 1

0

votes

1

answer

984

views

How to automatically set date in a cell when a different cell value is changed by a formula from data on another sheet?

google-sheets google-apps-script formulas google-sheets-timestamp google-apps-script-triggers

modified 2 days ago Community♦ 1

0

votes

1

answer

2k

views

How to prevent duplicate entry in google sheets per row

google-sheets formulas

modified 2 days ago Rubén 33.4k

1

vote

1

answer

526

views

Auto hide row based on cell text (formula based)

google-sheets google-apps-script formulas google-apps-script-triggers

modified 2 days ago Community♦ 1

0

votes

1

answer

29

views

How to add a note or comment into a formula in Google Sheets?

google-sheets formulas

modified Mar 31 at 11:59 marikamitsos 5,313

0

votes

4

answers

8k

views

LEFT JOIN two and more tables in Google Sheets

google-sheets formulas google-sheets-query google-sheets-arrayformula google-sheets-custom-function

answered Mar 31 at 0:36 SauloAlessandre 101

0

votes

1

answer

440

views

Unable to SUM column calculated by Array Formula

google-sheets formulas google-sheets-arrayformula

modified Mar 30 at 18:02 Community♦ 1

0

votes

1

answer

550

views

Concatenating URL with a value to create link, but links only partially work

google-sheets formulas google-sheets-arrayformula concatenate

modified Mar 30 at 3:02 Community♦ 1

-1

votes

0

answers

15

views

Auto fill a column with formulas when new rows are added

google-sheets formulas google-sheets-arrayformula

modified Mar 29 at 20:09 Rubén 33.4k

0

votes

1

answer

21

views

How to check separate sheet cell for any data, and return a Y?

google-sheets formulas google-sheets-arrayformula worksheet-function importrange

modified Mar 29 at 18:02 Community♦ 1

Browse more Questions

Web Applications Stack Exchange works best with JavaScript enabled