<div>
Hi,<br />
sorry but this will not work in calculated formulas as the &quot;Modified By&quot; column (with the internal name of &quot;Editor&quot;) is of type &quot;Person or Group&quot; which is an unsupported column type for calculation formulas.<br />
<br />
HTH<br />
Rainer
</div>


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

<div>
<div class="content wysiwyg-content">
is it possible to have a calculated field in Sharepoint list that will say something like this in the formula<br />
<br />
if the column 'Approved' =Y get name from Modified
</div>
</div>


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

Formula to select name modified by in Sharepoint

Microsoft Sharepoint is a software platform and family of software products used for collaboration and web publishing combined. These capabilities include developing web sites, portals, intranets, content management systems, search engines, wikis, blogs, and other tools for business intelligence and collaboration. SharePoint has a Microsoft Office-like interface, and it is closely integrated with the Office suite.

Microsoft SharePoint

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.