Formula in Smartsheet

HZAR

Hi

I have the formula as below and it working but when i add 1 more status it turn out error

=IF(AND([CM attention required]@row = "Yes", [PPV Status]@row = "MSI CM Review"), VLOOKUP(Commodity@row, {Category Managers Range 1}, 3, 0), VLOOKUP(Commodity@row, {Category Managers Range 1}, 2, 0))

Formula below have error since I have added 1 more status as need info

=IF(AND([CM attention required]@row = "Yes", [PPV Status]@row = "MSI CM Review","Need Info"), VLOOKUP(Commodity@row, {Category Managers Range 1}, 3, 0), VLOOKUP(Commodity@row, {Category Managers Range 1}, 2, 0))

May I know what is the correct formula? Pls help to advise. Thanks

KPH

Hi @HZAR

You need to include the range for the new criteria. See how the others are all pairs:

[CM attention required]@row = “Yes”

[PPV status]@row=“MSI CM Review”

but then you have “Need Info” without specifying which cell to look in. You need [column name]@row= before the criteria.

KPH

Hi @HZAR

You need to include the range for the new criteria. See how the others are all pairs:

[CM attention required]@row = “Yes”

[PPV status]@row=“MSI CM Review”

but then you have “Need Info” without specifying which cell to look in. You need [column name]@row= before the criteria.

HZAR

Hi KPH

Thanks for the point…now i know where is my mistake. Thanks 😍

KPH

Glad I could help @HZAR