Sep 09 2020 01:35 PM
How do I reference a field on a different spreadsheet that I want to pull a value from?
Sep 09 2020 01:43 PM
@lfayj1963
That's like
='Another sheet name'!A1
Sep 09 2020 01:45 PM
@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.
Sep 09 2020 02:32 PM
=GETPIVOTDATA("B",Sheet1!$F$4,"A","a1")
=GETPIVOTDATA("B",[PTfile.xlsx]Sheet1!$F$4,"A","a1")
=GETPIVOTDATA("B",'C:\Test\[PTfile.xlsx]Sheet1'!$F$4,"A","a1")
all works
