Hello, I have a table view grouped and sorted...

AppSheet AppSheet Q&A
1

Hello, I have a table view grouped and sorted by a date that representing the start of a week.

To prevent user confusion I’d like to display it as “Week of 2/4/2018” for example instead of just the date.

I created a virtual_week column

but the sort no longer works and the dates fall out of order.

Is there any way to display this text in front of the date and still follow the correct sort?

2

Unfortunately it won’t work because it will sort in a wrong way. If you want to sort it, you should create the format like “Week of yyyy/mm/dd”

3

Got it. Thanks Aleksi