Formula Question

Give this a try:

=IF([GSP Status]@row = "Cancel", "CANCEL", IF([GSP Status]@row = "Denied", "DENIED", IF([Final Settlement PO ($USD)]@row <> "", "CLOSED", IF(OR([Current Queue]@row = "Claim Approved", [Current Queue]@row = "Claim & Reserves Approved"), "Open - Approved", "Open - WIP"))))

@HZAR Try this:

=IF(OR(AND([Approval Required]@row = "1", [Type]@row = "Non MP"), [Type]@row = "MP"), VLOOKUP(Commodity@row, {Buyer Range 1}, 5, 0))

All comments

Itai Perez

Hi @HZAR

Can you share a screenshot to help visualize the issue?

Thanks

Give this a try:

Hi @Paul Newcome

Sorry for any late update. Thanks for the formula. It works as per required output. It is awesome

I have a question about my formula below which is giving me unparseable error. Is my formula wrong? If yes, can you show me the correct way. Thanks

=IF([Approval Required]@row = "1", [Type]@row = "Non MP"), IF(OR([Type]@row = "MP"), VLOOKUP(Commodity@row, {Buyer Range 1}, 5, 0)

The scenario that i would like to have

If Type is Non MP and approval required, then vlook buyer name

If Type is MP-vlook buyer name

@HZAR Try this:

=IF(OR(AND([Approval Required]@row = "1", [Type]@row = "Non MP"), [Type]@row = "MP"), VLOOKUP(Commodity@row, {Buyer Range 1}, 5, 0))

Hi @Paul Newcome

Thanks for the guidance as always ;)

Happy to help. 👍️

@Paul Newcome

I have a formula below but it giving me the error. Not sure what is causing the issue. Need your advise and help

=IF(OR([Item Status]@row ="Life Time Buy (LTB)", [Item Status]@row ="Bridge Buy (BB)"),"adrienanurashyiqin.bintizainol@gmail.com", IF([GSP Status]@row = "Cancel", "", IFERROR(INDEX({Site Ivt Lead}, MATCH([EMS Site]@row, {Site1}, 0)), "")))

The flow will be

Item Status=LTB or BB , EMS Site-Any-Lead name will be adreina

Items Status is not under LTB or BB, It will Vlook Lead name based on the EMS site

If GSP status =Cancel, Lead name will be blank

Which error exactly are you getting?

I get the #UNPARSEABLE error for this case. Thanks

Can you provide a screenshot of the formula open in the sheet as if you are about to edit it?

I have attached the screenshot. Thanks

Original formula will bee as below

IF([GSP Status]@row = "Cancel", "", IFERROR(INDEX({Site Ivt Lead}, MATCH([EMS Site]@row, {Site1}, 0)), ""))

As per the flow that is required I have amend the formula as below which is currently giving me the error

=IF(OR([Item Status]@row ="Life Time Buy (LTB)", [Item Status]@row ="Bridge Buy (BB)"),"adrienanurashyiqin.bintizainol@motorolasolutions.com", IF([GSP Status]@row = "Cancel", "", IFERROR(INDEX({Site Ivt Lead}, MATCH([EMS Site]@row, {Site1}, 0)), "")))

The flow will be

Item Status=LTB or BB , EMS Site-Any-Lead name will be adreina

Items Status is not under LTB or BB, It will Vlook Lead name based on the EMS site

If GSP status =Cancel, Lead name will be blank

Item Status column

Reference Column-Have link the Site with Name

I would need to see the formula that is throwing the error, and I would need to see it open in the sheet as if you are about to edit the formula similar to the snippet below:

I think the screenshot is not related to my ask I guess. Any update on my question. Thanks