1
vote
Accepted
Does Google Sheets have a function to insert X number of Y characters within a cell?
See rept():
Syntax
REPT(text_to_repeat, number_of_repetitions)
text_to_repeat - The character or string to repeat.
number_of_repetitions - The number of times text_to_repeat should appear in the value ...
- 13.2k
1
vote
Stuck at understanding how duplicate prevention formula works in Google Sheets
The range reference $A$2:A2 is using a mixed address mode where $A$2 is absolute and A2 is relative. When the formula is "dragged down" by copy-pasting cells or applying it to a range in a ...
- 13.2k
1
vote
Accepted
Automatic way to select a range for a formula based on the date
Use filter(), like this:
=map($A2:$A, B2:B, lambda(date, budget,
if(
isnumber(date) * isnumber(budget),
budget -
sum(iferror(filter(
Activities!C2:C,
Activities!$A2:$A =...
- 13.2k
Only top scored, non community-wiki answers of a minimum length are eligible