- Help Center Home
- Reports & Dashboards
- Tips & Tricks
-
General Navigation
-
System Forms
- Budget Amendments
- Budget Items
- Change Orders
- Contract Exhibits
- Contracts
- Cost Proposals
- Directives
- Drawing Packages
- Drawings
- Emails
- Field Reports
- Meetings
- Merge Documents
- Payment Applications
- Potential Change Orders
- Punch List Items
- Request For Information
- Request For Proposal
- Specification Packages
- Specifications
- Submittal Items
- Submittal Packages
-
Company Administration
-
Project Administration
-
Reports & Dashboards
-
Release Notes
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.
![](https://downloads.intercomcdn.com/i/o/150880850/e838cb74fc0047a3be9cf6ce/image.png)
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:
-
Click the Gear icon to edit report options
-
Click the Sorts option in the dropdown
-
Find your report category from the dropdown, then add your field to the sort
-
Click the function button (fx) to open the formula editor
-
Search for "Int" and create a formula that looks something like "=Int({Form Type.Row #})" (Substitute with your field)