Using ID Field in Calculated Column in SharePoint

In this article, I will explain

How to use The ID field in Calculated Column in SharePoint?

Scenario

I have tried to add ID field in a calculated column that added successfully without any error in the formula.

But I noticed that the calculated column is not calculated on the item added or updated!

Cause

Continue reading “Using ID Field in Calculated Column in SharePoint”

Advertisements

This o15.officeredir.microsoft.com page can’t be found when Edit List In SharePoint Designer

Scenario

I have tried to click on edit list in SharePoint Designer option from the list ribbon,

Edit List In SharePoint Designer from browser

but unfortunately, I got the below error.

This o15.officeredir.microsoft.com page can’t be found

No webpage was found for the web address:http://o15.officeredir.microsoft.com/r/rlidSPD2013Download?clid=undefined
HTTP ERROR 404

I have SharePoint Server 2013, and the SharePoint Designer 2013 is already installed.

Also, in Central Administration, the SharePoint Designer has been allowed to be used in this Web Application as shown below.

This o15.officeredir.microsoft.com page can’t be found
Cause Continue reading “This o15.officeredir.microsoft.com page can’t be found when Edit List In SharePoint Designer”

Create a New Project Based On SharePoint List Item In Project Server 2016

In this article, I will explain

How to bulk add projects from a SharePoint List into Project Server 2016?


Scenario

I have a “New Projects” SharePoint list, and I need to bulk add all list project items to Project Center in Project Server.

Solution

In Project Server 2013 /2016 as well as Project Online, you can easily import SharePoint list items into Project server by using “Create Project” button as shown below:

Create a new project based on SharePoint List item in Project Server 2016

The “Create Project” button will help you to create multiple projects from the sharepoint list items by mapping the SharePoint list columns with the Project Web App Fields.

This way would facilitate the Project creation process especially for the users who are not familiar with creating a new project in Project Center.

Note: There is no a specific number for the selected list items that will be converted/imported to Project Server. this is mainly depends on the current hardware specifications of your farm. Meanwhile, it’s recommended to convert from 5 to 10 list items to projects per one time.

Steps

Continue reading “Create a New Project Based On SharePoint List Item In Project Server 2016”