Can I Cross Reference a sheet in client account to a sheet in my account?

I'm trying to enter the following formula

=SUMIFS({Barcode packing lists Range 1}, {Barcode packing lists Range 2}, [PIckup Date]25, {Barcode packing lists Range 3}, [KIT# / SKU#]25, {Barcode packing lists Range 5}, "Green")

where the sheet "Barcode packing lists" is under my Smartsheet Account and the formula is on a sheet under my client's Smartsheet account.

I get the result #INVALID REF

Is there a problem with the formula, or can you only reference sheet within the same account?


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!