- BoostSolutions
-
Products
-
- Microsoft Teams
- HumanLike Alert Reminder
- View All Apps
- Pricing
- Support
- Company
When you add [Me] to a calculated column, there will be an error indicate you that [Me] does not work in calculated column. But the [Me] variable works in BoostSolutions’ Calculate Boost Field.
For example, there is a IT Request list in SharePoint, we plan to add a Calculated Boost Field named as requester and the value is [Me] (the current login user).
In this article, we will demonstrate how to use [Me] in Calculated Boost Field in a SharePoint list.
The Requester column shows the current login user
There is a SharePoint list named as IT Support with following columns and items on a SharePoint site.
Download the trial version of Calculated Boost and install it to your SharePoint server.
Navigate to the IT Support 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 Requester, then select Calculated Boost as the type of information in this column.
In the Additional Column Settings section, type this expression in the Formula box.
[Me]
This expression will catch the user name of current login user.
Specify the data type from this formula as Single line of text.
Unselect the option of Do real-time calculation if formula contains [Today], [Now], [Me], User field, Lookup field etc.
Keep other settings as default and click OK to create column.
Navigate to IT Support list and you will find that a column named as Requester is created in the list as following.
Login into IT Support list as user Cynthia Carey and create a new item and click Save button.
Then a new item is created in the IT Support list as following, and the Requester is the current logon user Cynthia Carey.
Login into IT Support list as another user Annie Walker and create a new item and click Save button.
Then a new item is created in the IT Support list as following, and the Requester is the current logon user Annie Walker.
