Protiviti / SharePoint Blog

SharePoint Blog

May 11
On the Clock: Defect Resolution

In any software development project there will be some level of testing for technical and end user teams. Spreadsheets are often used to track defects and can become cumbersome to update and route to team members.

A ready-made SharePoint solution is to leverage a custom list app for your tracking needs. SharePoint can lessen overall data entry, provide real time line of sight into progress, capture version history, as well as hold your team to your service level agreements regarding defect resolution.

One simple tip for calculating your service level agreements is to use the [Today] function and add on your anticipated duration for defect resolution. With a few simple clicks, you’ll be ready to go!

Assuming you have already created your Custom List App and named it “Assignments” navigate to the list settings.


Create one column and name it “Today.” Select the “Date and Time” format for the column data.

Select the default value for this column to be “Today’s Date.”

Save your column.


Create a second column and name it “Due Date.” This column will be your calculation column to generate the expected resolution date.


Add your formula by selecting from your other list app column choices and adding your number of service level agreement days. In this example it is 3 days or +3.


Start in the formula box by typing “=” and selecting “Today” from the insert column options. Select “Add to Formula” to move “Today” into the formula box. Manually type in +3 so that your formula in total reads = [Today] +3.


Save your column and you are almost ready to go! From your desired view, hide the “Today” column. Let it do the work behind the scenes and not clutter your team’s view. Each time a new item is created, SharePoint’s associated SQL database will being with “Today” as in the current date.


Here is your defect list in action with only the due date visible to the team.


To quickly and easily add a new item to the list simply select “edit this list” and the quick edit functions are activated.

In just a moment, I can report my defect and have its due date generated. Go ahead and fill out all items except for due date and then “stop editing this list.” If you find the Due Date field distracting, you can also hide the due date column from your view.

And automatically, your due date is calculated.

It’s quick and easy to set the standard for your defect resolution items with the creation of two simple columns.  Best wishes for speedy and timely defect resolution!


Quick Launch

© Protiviti 2020. All rights reserved.   |   Privacy Policy