Sort report by Row #

Turn row # fields into integers to be able to add a sort in your report.

If you have a collection that has many rows and shows a "Row #", you may want to sort your report based on that row number. 

For example, let's say we have a collection with 100 rows, number 1,2,3,4,...100. By default, the report will treat each row number as text and your result will not order your rows correctly.

To fix this, you need to add a function to your "Sort" that turns each row number into an integer. In your report setup, follow the steps below:

  1. Click the Gear icon to edit report options

  2. Click the Sorts option in the dropdown

  3. Find your report category from the dropdown, then add your field to the sort

  4. Click the function button (fx) to open the formula editor

  5. Search for "Int" and create a formula that looks something like "=Int({Form Type.Row #})" (Substitute with your field)