SharePoint List- Calculated column to return active changes & non active changes

Question

Hi Team

I require a calculated column for my SharePoint list to return "Active changes" if the 'Change Status' field =

0 Triage in progress
1.New
2. Scoping & Planning
3. Deployment & Implementation
4. Hypercare & Adoption
5. Backlog
10. Reactivated

To return "Non Active changes" if the 'Change Status' field =

6. Completed
7. Cancelled (not to proceed)
8. Closed (no impact to B&PB)
9. Closed - Minimal Impact to B&PB

If I could please have the formula for the above, it'll be greatly appreciated.

Kind Regards,
Harry

Answer 1

You could use following formula in the calculated column.

=IF(OR([Change Status]="Triage in progress", [Change Status]="New", [Change Status]="Scoping & Planning", [Change Status]="Deployment & Implementation", [Change Status]="Hypercare & Adoption", [Change Status]="Backlog", [Change Status]="Reactivated"), "Active changes", "Non Active changes")

Result:

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.