fill_formula
Fill a range with a formula, automatically adjusting relative references to match each cell, similar to Excel's fill handle.
Instructions
Fill a range with a formula, adjusting relative references like Excel's fill handle.
The formula is written as given to the range's top-left cell and translated for the rest: '=B22' filled into C2:C4 becomes '=B32' in C3 and '=B42' in C4. Use $ to pin references ('=$B$1B2').
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| range | Yes | ||
| formula | Yes | ||
| session_id | Yes |