Answer the question
In order to leave comments, you need to log in
How to apply a formula to an array of strings so that the display is displayed in the cell on the right?
How to make automatic insertion of the current time in Google spreadsheets when entering data in an adjacent cell? This topic was covered in this question, but not quite.
When talking about an array, it throws an error in the value #ЗНАЧ!
. =ЕСЛИ ( F9:N9<>0 ; ТДАТА (); " " )
Google climbed and did not find the answer, so I turn to you.
Answer the question
In order to leave comments, you need to log in
Most likely, we are talking about applying a formula to a range of cells or an array of data. To do this, use the ARRAYFORMULA formula in Tables.
Example
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question