Automation Blocks - Modify Update Texts of Ae Mogrt to recognize column name, not number

[Citizen_Sam]

Hi @Mathias Moehl 

I'm crafting a variation of the Update Texts of Ae Mogrt with Spreadsheet script (another upskilling from my current knowledge base given the way it works).

I want the target coumn index to be dynamic, and dependent on other data in the project (potentially sequence name).

To start that process, I'm hoping you can answer this first question - can the variable "target column index" be tied to the text in row 1 of the spreadsheet, as opposed to just the column number? Example - Cell 1B is titled "this column" and we've defined the variable "target column index" as "this column"

[Citizen_Sam]

I actually figured out a way to do it (sort of)!
I wrapped all the blocks below the "set my row" variable block into an If/Do block...
If name of sequence = get cell of spreadsheet file in row my row and column target column index

So it only completes the script of the sequence name matches the target cell.

[Mathias Moehl]

Not sure if I fully understood your issue. But if you want to read the target column index from the spreadsheet itself, you could do it like this: