Solved: Sort by column value unless row is Pinned to top - Page 2

jonbowles84 · 02-26-2022 10:23 PM

I have a table "noticeboard" where rows are sorted by [Posted] which is just time row was created. I would like to have the ability to pin a row in the noticeboard to the top, so if its pinned it remains at the top no matter the value of [Posted] and the rest are sorted by [Posted] still.
I cant seem to find a solution to this?

Joseph_Seddik

OK, I see. Thank you.

Move the expression from App Formula to Initial Value, and add the following expression as an "Editable if" constraint: ISBLANK([_THIS])

By the way, since you have a Staff table, instead of the ANY(SELECT()) expression you mention you should do the following:

The "Author" column should be a ref to your Staff table, where the "email" column should be the key.
In your Staff table, make the "Full Name" column as Label.
Now, the initial value expression should simply be: USEREMAIL().

View solution in original post