How to save calculated result to current list item | Collection Column - BoostSolutions App, Saas & Software for Microsoft 365, Microsoft Teams, SharePoint

How to save calculated result to current list item?

In a BoostSolutions’ Collection Column, you can list multiple items on another list item and calculate data using formulas and functions.

In this article, we will separate each project into 4 subtasks, and each subtask accounts for 25%. Now, we need to design a formula to calculate the project’s complete percentage based on the subtasks completed and save the result to the project.

Now, let’s get started.

WHAT YOU'LL GET

The % Complete of project ARB Module 1 is the sum of all the subtasks

WHAT YOU'LL NEED

Collection Column

The sample data we use for this case

And there is another list named as Tasks of ARB Project, the list includes these columns as following.

Save calculated result to current list item

Download the trial version of Collection Column and install it to your SharePoint server.
Navigate to the ARB Project list, click List tab. In the Manage Views group, click Create Column.
In the Name and Type section, enter a name in the Column Name field to give it a meaningful name such as Subtasks, then select Collection Column as the type of information in this column.
In the Additional Column Settings section, keep all settings as default.
In the Source List section, select Tasks of ARB Project from the drop-down list.

Select Task Name, Priority, Task Status, % Complete, Assigned To, Start Date and Due Date column as Editable as following.
In the Calculated column section, specify a name for this expression name, such as Total Days, then type this formula in the formula box as following.

[% Complete]*0.25

This formula will calculate the percentage of each subtask in the current project.
In the Total Settings section, select Sum for Progress and select % Complete to save the results..
Keep other settings as default and click OK to create column.
Navigate to ARB Project list and you will find that a column named as Subtasks is created in the list as following.
Select item ARB Module 1 and edit it.

In the Subtasks column, create four subtasks, then the Progress column will show the calculated results.

At the bottom of Subtasks column, you can see a “Sum” field with the total percentage of subtasks.
And then click Save button to save the changes.
You will find that there are four items in ARB Module 1 item as following. and the % Complete of project ARB Module 1 is the sum of all the subtasks as following.