If statement

[Anonymous]

I had a project where the following worked for me: if(match(Status, 'Active', 'Requested'),  today() - [Date Rqstd]) as [Days Outstanding],

Now I am trying to use other statuses & no go

if(match(Status, 'Work in Progress', More User Info needed'),  today() - [Date Rqstd]) as [Days Outstanding],

any help will be appreciated.

thx

jude

[sunny_talwar]

What is the issue you are running into? May be a missing single quote?

if(match(Status, 'Work in Progress', 'More User Info needed'),  today() - [Date Rqstd]) as [Days Outstanding],

[Anonymous]

Ok, let me check that.  So multiple status values in one statement are ok?

[sunny_talwar]

Yes it does, as long as you are using a match/wildmatch/mixmatch function....