I'm having a problem with this formula, #Invalid Operation referencing another sheet.
=IF(CampaignCode1 = {Oracle ANZ Marketing Calendar CampaignCode}, {Oracle ANZ Marketing Calendar Pillar})
I'm wanting to look at the master sheet, match the campaign code and display the Pillar, can someone please help?
Answers
-
Try something along the lines of...
=INDEX({Oracle ANZ Marketing Calendar Pillar}, MATCH(CampaignCode1, {Oracle ANZ Marketing Calendar CampaignCode}, 0))
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!