Getting sheetnames to appear in certain order in a report

Phil Wightman

Hi there,

Can anyone help with how to configure sheet name so it appears in a particular order when shown in a report?

I have used numbers (1. Red, 2. Yellow....) and letters (A. Red, B. Yellow....) but both approaches do not work consistently.

A-G seems to work but the following letters dont (see image) .  The numbers seem to have a problem when you get to 10 which lists before 1.

Andrée Starå

Hi Phil,

In some instances, some numbers can be interpreted as text instead. The order after G is strange.

Have you selected the sort order in the Report Builder?

If you haven’t already, I would recommend that you reach out to the Smartsheet Support Team. Smartsheet Support Team

I hope that helps!

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD