PythonNot a big fan of functions?
Use the Actions Wizard to configure any action in Rows without functions.
Parameter List
Syntax
PYTHON(script,
[range1]
, [range2]
)script
A string for your Python code, referencing input ranges with xl(), which must match the defined range parameters. For example: xl("Table1!A1:B2"). More details here.
[optional] range1
The first range of cells to be used in the script. To access the range use the xl() function. For example, xl("'Report'!A1:C2")
[optional] range2
Additional ranges of cells (optional). Inside the script, these are accessible via xl function. You can pass as many ranges as needed.