Calculated fields or computed fields are a feature that allows users to perform calculations based on values from other fields within the same project. They are typically used to automate the calculation of values that would be time-consuming or error-prone to do manually.
Bridge24 offers six calculated fields for Asana, Basecamp, and Trello. These fields can be used in most views: grids, charts, reports, and exports.
Age (days): The amount of time (in days) that has passed since the task was created. We calculate the value using the “Created At” field with today’s date.
Completion (days): This represents the number of days it took to complete the task since its creation. We calculate the value by taking the “Completed At” and the “Created At” fields.
Completed Late: This represents whether a task was completed on time. We calculate the value by taking the “Completed At” and “Due-Date” fields. If the “Completed At” value is higher than the “Due Date”, the task was completed late.
Completed Late (days): This represents the number of days the task was late or completed in advance. We calculate the value by taking the “Completed At” and “Due-Date” fields. For example, if a task is originally scheduled to be completed in 5 days, but it takes 8 days to finish, then the task is completed late by 3 days. The Completed Late field would indicate this delay as a positive number or a negative number if the task was completed in advance.
Attachments (number): Refers to the total number of files or documents associated with a particular task. By sorting with this field, it’s easy to find tasks with files attached.
Comments (number): Refers to the total number of comments associated with a particular task. By sorting with this field, it’s easy to find tasks with comments attached.
Completed Late Use Case
The completed late field can be used to track the days a task was completed after its scheduled completion date. Here are some use cases for using the completed late field:
- Identifying potential issues: By monitoring the completed late field, project managers can quickly identify tasks that are consistently completed late and take corrective action to improve the project schedule.
- Assessing team performance: The completed late field can be used to evaluate the performance of team members in completing tasks on time. This can help identify team members who may need additional training or support.
- Adjusting project timelines: By reviewing the completed late field, project managers can adjust the project timeline or adjust the schedule of tasks to ensure that future tasks are not completed late.
- Communicating with stakeholders: The completed late field can be used to communicate with stakeholders about the progress of the project and to manage expectations about the delivery of project milestones.
- Analyzing project data: The completed late field can be used to analyze project data and identify trends or areas of improvement in the project planning and scheduling process. This can help project managers to make data-driven decisions and optimize project outcomes.
Age Use Case
The age field can be used to track the amount of time that has passed since a task was created. Here are some use cases for using the age field:
- Task prioritization: The age field can be used to prioritize tasks that have been active for a longer period of time. This can help project managers to identify and address tasks that are at risk of being delayed or that require urgent attention.
- Tracking task progress: The age field can be used to track the progress of individual tasks by providing a snapshot of how long each task has been active or waiting for action. This can help project managers to ensure that tasks are moving forward and identify potential bottlenecks.
- Resource allocation: The age field can be used to allocate resources to tasks based on their level of activity. For example, tasks that have been active for a longer period of time may require more attention from team members or additional resources to complete.
- Reporting: The age field can create reports showing how long tasks have been active or waiting for action. This can help project managers communicate the project’s status to stakeholders and provide updates on task progress.
Overall, the age field is a useful tool for tracking the progress of tasks and projects, and for identifying potential issues or areas of improvement.