New Contributor

How do I reference a field on a different spreadsheet that I want to pull a value from?

3 Replies


That's like

='Another sheet name'!A1

@Sergei Baklan I entered this  =GETPIVOTDATA('[CCC Plus Dashboard Call Center 08.01.20 to 08.31.20.xlsx]Call Center 08.01 to 08.31 DATA'!$G$6) and I'm getting the error You've entered too few arguments for this function.







all works