#Invalid Ref using Marketing Campaign Management Template

AMY B.

I used the marketing campaign management template and created a new campaign, however under my campaign Info sheet I am getting a #invalid ref on all cells. I have verified the formula is correct and the range (using the sample campaign as a guide) and am at a loss. Because of this error the information on my campaign plan sheet is also not reading through correctly.

Paul Newcome

That particular error means a {Cross Sheet Reference} has not been set up yet. I would suggest going through your formulas and clicking inside of each {Cross Sheet Reference} one at a time. If the small blue link in the formula help box reads "Reference Another Sheet", that {Cross Sheet Reference} has not yet been created.

https://help.smartsheet.com/articles/2482644-create-cross-sheet-references

.