Does reordering columns impact any other existing logic? The column title would remain unchanged

Andy S.

Does reordering columns impact any other existing logic (datamesh, formula, workflow, helper columns)? The column title would remain unchanged.

Specifically, is there any reason this could impact a helper column using a formula that references the column being reordered?

Darren Mullen

@Andy S.

Most formulas won't be impacted by reordering columns, however there are some cases where reordering columns would have impacts. I can't guarantee this list is exhaustive, but it's what I can come up with:

1. VLookup formulas will be impacted
2. If you are using an INDEX() formula and referencing a column index, this would be impacted
3. API Integrations that rely on the index of a column

So, you can see if you have any formulas or API scripts that are expected a column to be at a certain index in the sheet, they'd be affected. Otherwise, there shouldn't be any impacts other than visual.