6 февр. 2024 г. · I want this formatting to change the color of the current cell depending on if it's value is within 0.5 more or 0.5 less of the previous cell value.

31 дек. 2023 г. · The "range" expression pulls the values from the top of the current column until the row above the cell, "nonblank" removes blank values, and ...

12 дек. 2019 г. · I'd like to have a specific cell (in my case, cell AC3) to automatically update with the value of the currently active cell.

27 июл. 2022 г. · I have a column of negative numbers that I want positive. My thought would be =IF(NOT(IS BLANK(CELL()), CELL = CELL * -1). But I'm receiving the error.

15 окт. 2023 г. · You'll need to use the INDIRECT() function to make a reference with the ROW() function work, i.e. =INDIRECT("D"&ROW())-INDIRECT("F"&ROW())- ...

30 мар. 2022 г. · I have a running log of data on a Google sheet. I have it set up to add the next day's entry between 11 pm and midnight, copy the previous day's entry and ...

1 день назад · Hello I need some help please. Current sheet layout. Column C: Name Column Q: Date (text value) Column L: Target output location.

15 июн. 2023 г. · I want this cell to auto-populate the weight goal that corresponds with the current date. I'm assuming it's some mix of TODAY, INDEX, MATCH, and/or VLOOKUP ...

21 янв. 2024 г. · Is there a shortcut that pastes whatever is in the above cell into the currently highlighted cell?

13 нояб. 2019 г. · Select the cell, then press Format > Number. If nothing is checked, More Formats > Custom Number Format.