Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 226
  • Last Modified:

Formula to select name modified by in Sharepoint

is it possible to have a calculated field in Sharepoint list that will say something like this in the formula

if the column 'Approved' =Y get name from Modified
0
Jagwarman
Asked:
Jagwarman
  • 2
1 Solution
 
Rainer JeschorCommented:
Hi,
sorry but this will not work in calculated formulas as the "Modified By" column (with the internal name of "Editor") is of type "Person or Group" which is an unsupported column type for calculation formulas.

HTH
Rainer
0
 
Rainer JeschorCommented:
And alternative ways are:
1. Using a workflow
2. Using a scheduled Powershell script
The script should simply run a SPQuery to get all list items where Approved = Y and your  new column <> Modified By column
Tricky part would be to update the list item without changing the timestamps and modified by :-)
But this code should help:
http://www.sharepointsapiens.com/blog/update-item-document-properties-without-changing-modified-modified-fields-using-sharepoint-powershell/

HTH
Rainer
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now