I have a downloaded file that may have the columns in any order. I have an automation in which I insert a column AFTER a named column (e.g., insert a column “FullName” after the column “LastName”), and then I want to populate a formula in the new column (e.g., a formula that combines “FirstName” and “LastName”). However, I can’t find a way to reference the new column by its header, such that I can populate the new column with a formula. Because it can be anywhere on the sheet, I can’t reliably say to populate column N, for example.
Is there a way to reference a column by its header in StudioX so that I can Write Cell in, for example, “FullName” row 2, and then autofill the rest of column?