1
vote
Accepted
How to make arrayformula automatically applied to newly inserted rows?
Reserve row 1 for headers by choosing View > Freeze > 1 row and change your workflow so that you always insert new rows below row 1.
Then clear column B and put this formula in cell B1:
=...
- 13.2k
1
vote
Choose an employee and show the days where he has a specific shift code , along with the employees with the same shift
I feel like there must be a simpler way of doing this, but the below seems to work...
=arrayformula(let(
names,A2:A7,
days,B1:H1,
shift_tbl,B2:H7,
name_filt,B10,
shiftcode,"22-06",
...
1
vote
Extraction social hashtags with diacritics from a cell?
Use regexreplace() to remove all characters except those that match #ànyTéxt or #ànyTéxt!, i.e., a hashtag followed by whitespace or punctuation. For that to work, you'll have to append a space to ...
- 13.2k
Only top scored, non community-wiki answers of a minimum length are eligible