Use the Formula Column to Calculate Remaining Work in Your Project
Formula columns help automate calculations across your project, saving time and improving accuracy. Follow these instructions to set up a formula column that tracks remaining work by subtracting the current work count from the target count.
1. Navigate to the Custom Columns
Click the plus (+) symbol to start adding a new column.
2. Add the Formula column
Select New column and search for Formula.
Click Add next to the Formula column option.
3. Enter the details of the column
Enter a name for your column (like “Remaining Work”). The column type should already be set to Formula.
Optionally, add a description. Leave this blank if it’s self-explanatory.
Click Add column to create your formula column.
4. Edit the details
Click the new column to open the formula editor.
In the editor, choose to use a Basic formula.
Find and select the Target count property, then pick the subtract symbol (-).
Select the Current Work count property to complete the formula.
5. Save the Formula
Click Save to apply your formula.
Watch your values auto-populate, showing the remaining work for each task.
Formula columns make project tracking smarter and faster.
Use them to automate calculations like remaining work, project totals, or performance metrics to keep your projects organised and up to date.
