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?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!