Solved

Formula to select name modified by in Sharepoint

Posted on 2015-02-13
2
124 Views
Last Modified: 2015-02-17
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
Comment
Question by:Jagwarman
  • 2
2 Comments
 
LVL 44

Expert Comment

by:Rainer Jeschor
ID: 40608037
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
 
LVL 44

Accepted Solution

by:
Rainer Jeschor earned 500 total points
ID: 40608054
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

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
I thought I'd write this up for anyone who has a request to create an anonymous whistle-blower-type submission form created using SharePoint 2010 (this would probably work the same for 2013). It's not 100% fool-proof but it's as close as you can get…
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now