Reference 2 columns from a separate sheet
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
-
What is the desired outcome of this formula? What exactly are you trying to accomplish?
-
In the column of the formula I am trying to retrieve if the role column is blank then I need it to return a 0 but if it has text in it I need it to reference a separate sheet and two separate columns within that sheet. One column (Business Rule - CSR Indicator) returns a 1 or 0 and I need that to match what the other column (Business Rule - CSR Role) has entered which are different roles that answer the question of the Indicator column. Does that make sense?
-
Are you able to provide some screenshots for reference?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.1K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 444 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 290 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!