Automation email fields sort order not retained

BrianJ

I am having an issue with the linked to sheet and select fields of an email used in an automation not saving properly. This is frustrating because I would like the information in the generated to be in a logical and consistent manner across sheets. This is compounded by the inability to drag and drop the fields to organize them in a particular order.

This is the order that I specify before saving:

This is the order after saving and reopening:

I am not sure what is going on. Anyone else having this issue?

Thanks,

Brian

Paul Newcome

Have you tried reordering the columns in the sheet?

BrianJ

Thanks Paul. The new order does not reflect any underlying column order in the sheet. The columns are set up as follows (with the ThisWeek column being a locked and hidden column to the left of Schedule Health):

Paul Newcome

How does it actually send in the email?

BrianJ

The email included a table with the following columns: Task Name, Status, Assigned To, Start Date, End Date, and % Complete. So they are not in the same order as the original or what is showing when I go in and click edit. I may delete these automations and set up from scratch again to see if that fixes it. I am seeing this behavior on one project sheet, but I am not seeing it on others.

BrianJ

To follow up, I deleted and added an additional automation from scratch with the same result.

Paul Newcome

But it does sound like the email is presenting the columns in the same order as the sheet.

BrianJ

Yes. I hadn't thought of that. I will reorder the columns for consistency. It is interesting that it doesn't reflect the order that you put in the automation. Thanks!

Paul Newcome

That is certainly interesting and something I had never noticed.