Last Modified User formula field

Question

I'm trying to create a formula field that would stamp the User that set Lead Status to Rejected?

Error: Incorrect number of parameters for function 'TEXT()'. Expected 1, received 3

IF(TEXT(Status,"Sales Notified","NULL") ||

IF(TEXT(Status,"Accepted","NULL") ||

IF(TEXT(Status,"Rejected","LastModifiedById"),1)))

Deepak K Anand · Accepted Answer

Nah! You need a Workflow Rule + Field Update and Text Field to capture this.

Evaluation Criteria: created and every time it's edited to subsequently meet the criteria [ 3RD OPTION ]
Rule Criteria: criteria are met
Criteria:
```
Lead Status equal to Rejected
```
Add a Field Update
Field to Update: Last Modified By (New Text Field)
Use a Formula
Formula -
```
$User.FirstName + ' ' + $User.LastName
```
Don't forget to activate

Collaboration