ISBLANK and INDEX MATCH

Chris Martin

HI

Having an issue with this function. Im trying to return a certain accounting code of which the index is going to look up. but it only needs to run if the Shopify ID is blank.

IF shopify id is blank perform index match function, if not blank return a value

I keep getting unparseable errors

=IF(ISBLANK([Shopify ID]@row), (INDEX({Client Delivery Database v2 Range 1}), MATCH([Customer Input]@row, {Client Delivery Database v2 Range 2}, 0), "207")

What am I doing wrong

Cheers

Chris

Kelly Moore

Hey Chris

As a small tweak to Ayelet's suggestion above, if that suggestion doesn't work, try

=IF(ISBLANK([Shopify ID]@row), INDEX({Client Delivery Database v2 Range 1}, MATCH([Customer Input]@row, {Client Delivery Database v2 Range 2}, 0)), 207)

This removes the inadvertent leading parenthesis in front of Index and also removes the quotes around a number. Numbers shouldn't have quotes around them, otherwise smartsheet will treat them as text.

Kelly

Ayelet Weiner

=IF(ISBLANK([Shopify ID]@row), (INDEX({Client Delivery Database v2 Range 1}), MATCH([Customer Input]@row, {Client Delivery Database v2 Range 2}, 0), "207")

Try removing the ) after the first range within your INDEX and add a ) after the search type in your MATCH portion. See if that works.

=IF(ISBLANK([Shopify ID]@row), (INDEX({Client Delivery Database v2 Range 1}, MATCH([Customer Input]@row, {Client Delivery Database v2 Range 2}, 0)), "207")

Kelly Moore

Hey Chris

As a small tweak to Ayelet's suggestion above, if that suggestion doesn't work, try

=IF(ISBLANK([Shopify ID]@row), INDEX({Client Delivery Database v2 Range 1}, MATCH([Customer Input]@row, {Client Delivery Database v2 Range 2}, 0)), 207)

This removes the inadvertent leading parenthesis in front of Index and also removes the quotes around a number. Numbers shouldn't have quotes around them, otherwise smartsheet will treat them as text.

Kelly

Chris Martin

thanks team, looks like some pretty amateur mistakes. Thanks for your help