Nested IF with multiple functions included returning unparseable


I have a complex sheet along with a Metadata sheet and wanting to add certain results according to the following formula. =IF(UPN@row <> "", (IF(CONTAINS("VFD", [Equipment ID]@row), "1823", (INDEX({Cardinal Metadata - UPN & UPI List 'WBS'}, (MATCH({Cardinal Metadata - UPN & UPI List 'UPN'},@row, 0), 0))), "") No matter where I think the error is its kicking my brain this morning. The desired outcome is either an empty cell 1823 if the id contains VFD or WBS number matching its UPN per the Metadata sheet.

In advance thanks for any help that can move me forward

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!