Sorting using Linked fields from parent sheets


#1

I have a sheet that uses “linked fields from parent sheets”. On the listing page for the sheet there are no sort options for those fields but there are for fields belonging to that form/sheet.

Is it not possible to sort a list view using linked fields from parent sheets? Or is this a glitch?

Thanks


#2

Hi,

The field inserted by “linked fields from parent sheets” is for displaying purpose. Since the field value is not stored in this sheet at the backend, you won’t be able to sort based on that field.

A workaround is creatinga free text field and apply formulas so that the field value will always equal to the field inserted by “linked fields from parent sheets”. Then, sort based on the new field.


#3

Thanks Angie.

I managed to resolve this by using additional link and load fields.

Thanks.