In this article, we will cover how to configure columns in the Worksheets tab by creating a sample column.
This article applies to the MeasureSquare Bid.
Download this file here and add it to your MeasureSquare Cloud to follow along.
1. Open up the project you want to work on and navigate to the Worksheets tab in the top bar
2. Click the gear in the top right corner
3. To create a new field click Add Custom Field and set a Field Name
4. For items that are not dollar amounts, click on Field type and choose one of the options below
Optional: Edit Field Description to talk about what the column will do
5. To hide the column from view on the worksheets screen but still use it in calculations, set Hide Field to on
6. To show the sum of all values in the column on the worksheets screen, set Show Column Total to on
7. To edit the Formula, click on the Formula Box then click Clear
7a. The top row contains functions that you can use
7b. The middle section contains fields that are pulled directly from MeasureSquare
7c. The bottom section contains other columns
9. Using the Formula editor create a formula
10. On the left side of the screen, drag and drop the Column to where you want to have it
11. Changes will automatically be saved, click Close