Way to copy Custom Action to other components?

An arrayformula affects all rows, so you only need to type the formula once and it affects all rows in that column. If a row is empty, then you can do a length check on a column that would normally be filled, so you can have it show a blank value instead of an error or zero if the row is not populated with anything yet.

I would recommend reading through this post.

3 Likes