@if and @contains

HCL Domino Domino Forum
1

I’m trying to write a formula for my view. I need to use the @contains formula but I’m having trouble.

my field I am pulling from in Status.

I need all the contain “Receiving” to say receiving.

All that contain "purchasing to say purchasing,

All that contain “requistioner” to say requisitioner.

else I need them to just show the status.

I need to do this because my status’s for receiving are : receiving1, receiving2 etc. the same with purchasing and the requisitioner.

I have 5 different statuses that I want to show

Completed

AP

Receiving

Purchasing

Requistioner.

I do not want to show the actual status of Receiving1, receiving 2 etc…

2

Subject: What have you tried that failed?

Should be pretty simple, something along these lines:

@IF(

@Contains(Status;“receiving”);“receiving”;

@contains(Status;“purchasing”);“purchasing”;

@contains(Status;“requisitioner”);requisitioner;

Status)

3

Subject: @if

I found what I was doing, thanks to your response. I was putting a ) in the wrong place. I’m still very new and learning from mistakes. Thanks a bunch.