The app is a handy contractor tool to help keep track of projects. The app is connected to a spreadsheet where all the project information, including costs is laid out for a project. The contractor can keep track of the project estimate and actual costs and progress of the different jobs performed in the project. As an additional bonus, the contractor can share the app with the customer so she/he can also keep track of expenditures and overall progress.
Planning & Project Management
An app for contractors to track projects, including costs and progress shown via a chart.
We built this app in under two hours. The contractor app includes Charts, grouped lists, and conditional formatting to help the user navigate the data. Here are some design highlights:
1. The app contained numeric data and formulas in the spreadsheet. We decided to show a chart that compared estimated and actual costs by going to Advanced Editor > UX > Controls and added a view of type Chart - Col Series. AppSheet automatically built an app using columns with numeric data, we then selected a second column in the new view to compare two data points.
2. We grouped the sheet by status and by Area using the UX view and selecting the appropriate grouping method when selecting List - Grouped.
3. We added conditional formatting to show Complete projects in green and Not Started in Red. To achieve this, we went to Advanced Editor > Data > Slices and created two slices. One to for data when status equals Complete and one when status equals Not Started. We then went to Advanced Editor > UX > Formatting and created two formatting rules, one called Complete that pointed to the slice showing complete jobs, and another one pointing to the slices showing not started jobs.
To learn more about formatting, go to: https://appsheethelp.zendesk.com/hc/en-us/articles/206122068-Conditional-formatting
Copy this app for free and customize it with your own branding and projects!
Choose a Sheet
To find the ID of a sheet, go to the Smartsheet site, open the Properties of the sheet, and copy the ID property.