Google-sheets – How to autofill specific cell when any next cell is filled

google sheetsgoogle-sheets-arrayformulagoogle-sheets-dates

+------------+---------+---------+
|    Date    |  Col1   |  Col2   |
+------------+---------+---------+
| 2018-01-01 | Value 1 | Value 1 |
| 2018-01-01 | Value 2 | Value 2 |
| 2018-01-01 | Value 3 | Value 3 |
+------------+---------+---------+

I want to autofill Date column's cell with current date, when any of the Col1 and Col2 is filled in that row.

How can I do that, Is there any formula or need to write script ?

Best Answer

You could use this formula

=ARRAYFORMULA(IF((W10:W13<>"")+(X10:X13<>""),TODAY(),""))

and then give the desired date format to the results from the menu.
(Please adjust ranges to your needs)

Functions used:

Related Solutions

Google Sheets – Hide Row When Specific Cell is Filled

You need a script for this. This script runs on every edit (onEdit), checks whether the edit is in the 5th column (E), and if the new value is 1, then it hides the row of that cell.

function onEdit(e) {
  if (e.range.getColumn() == 5 && e.value == 1) {
    e.range.getSheet().hideRows(e.range.getRow());
  }
}

Google-sheets – Hide row if cell contains specific text

function onEdit(f) {
  if (f.range.getColumn() == 6 && f.value == "A" || f.value == "B") {
    f.range.getSheet().hideRows(f.range.getRow());
  }
}

Best Answer

Related Solutions

Google Sheets – Hide Row When Specific Cell is Filled

Google-sheets – Hide row if cell contains specific text

Related Topic