Reference 2 columns from a separate sheet

Options

Hello - I am trying to reference and Match 2 columns from a separate sheet. I am using ISBLANK. Here is the formula below that I am getting Unparseable


=IF(ISBLANK([Role]@row, "0", {Business Rule - CSR Indicator},{MATCH[Role]@row,{Business Rule - CSR Role}})

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!