Automation email fields sort order not retained
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
Answers
-
-
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):
-
-
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.
-
To follow up, I deleted and added an additional automation from scratch with the same result.
-
But it does sound like the email is presenting the columns in the same order as the sheet.
-
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!
-
That is certainly interesting and something I had never noticed.
