Sorting date in excel mix-up content...?!

Help from Community
1

Hello Intuiface Community! :wave:

I created an experience with an Asset Grid, displaying a title, a date, and an image.
The content comes from a small spreadsheet (Contenu.xlsx).
As users can add content in a non-chronological order, I added a sorting action on the date.

And that’s where fun begins
 :face_with_raised_eyebrow:

Sorting date works fine for title, date and simple text


but the last column (image dynamic reference, last line of the asset grid) gets mixed-up somehow! :scream:

I tried different formulas (=“Image/”&C2&".png" ; =CONCATENER(“Image/;C2;”.png") but ended with the same result


Problem
Problem.PNG962×536 48.7 KB

Here is the project:
Projet bug excel.zip (6.3 MB)

Has anyone encountered a similar problem? :thinking:

Any idea where this might come from? :sob:

Thanks,
Gérémy

2

Hi Geremy,

The issue comes from the mix of sorting + Excel formula.
I recommend you to put directly the relative path without formula.

I ran a quick test, see below, top image is using an Excel CONCATENATE formula, bottom image is a direct path:

Before sorting

image
image.jpg2273×1525 569 KB

After sorting

image
image.jpg2286×1576 578 KB

I’ll follow up with our Product Team about that.

3 Likes
3

Hi Alex,

Thank you for your quick reply.
Yes, seems’ like avoiding formulas does the trick. :upside_down_face:

I will tell users to enter full relative paths for the moment, and we will keep an eye on future updates on this matter! :wink:

Thanks,
Gérémy