79089699

Date: 2024-10-15 11:29:26
Score: 0.5
Natty:
Report link

You can use a template literal:

var rngForForm = `$B$3:$B$${N}`;

You could also use R1C1 notation:

var trimData = mySheet.getRange(3, 2, N-2).setFormula(left);
Reasons:
  • Whitelisted phrase (-1.5): You can use
  • Probably link only (1):
  • Low length (1):
  • Has code block (-0.5):
  • Low reputation (0.5):
Posted by: user27425627