Sort Excel report by email by date descending

[Jennie_Lewis]

Hi -
I have an Excel report attachment that I would like to order by date descending.

I’ve tried the Orderby start expression listed here - but it is not working. There is not an error, the report just does not send.

help.appsheet.com

Template Start Expressions

Using Start expressions in your workflow templates.

This is the default (current) start expression I’m using.

<<Start: Filter(MoodTracking, true)>><<[Mood]>>

This is the date field I’d like to sort by.

[DateOccurred]

Any ideas would be appreciated. Thank you!

[Steve]

Try:

<<Start: ORDERBY(Filter(MoodTracking, true), [DateOccurred], TRUE)>>

[Jennie_Lewis]

Thanks for the reply!

No errors when I save that, and the report still runs. But - the data values are turned in to numbers in the results.

I tried your format & also this with additional ():

<<Start: ORDERBY((Filter(MoodTracking, true)), [DateOccurred], TRUE)>><<[Mood]>>

[Steve]

Please post a screenshot of your template.

[Jennie_Lewis]

[Steve]

Perhaps the cell format for column C needs to be changed? I would guess it’s set to Number when it be Date or Automatic.

[Jennie_Lewis]

Formatting the column as date does update the format to a date from a number. But the “recovery time” column (enum values) still returns as numbers.

The other issue is that the data shifts over to the left by one column. Values for the Image column are showing up in notes.

Values shifted to left:

Original format for recovery time & date occurred:

[Steve]

Jennie_Lewis:

But the “recovery time” column (enum values) still returns as numbers.

Perhaps change the format of those cells to match the base type of the Enum values?

[Jennie_Lewis]

That helped! Thank you!