So I have a Google Sheets file which basically compares the sum of hours based on some criteria between two pivot tables. To do so, I use the following formula:
=GETPIVOTDATA("Qty",'Pivot Table QB'!$A$1,"Name",A2,"Engineer",B2,"Date",text(C2,"M/DD/YYYY"))
It works just fine, but I'm honestly just curious as to why I have to convert the date to text in order for it to work. If I just reference cell C2 on its own, I get a reference error. I checked and I made sure all the date formatting is consistent across the file, so I'm just confused as to why that is. In Excel, just referring to the cell works just fine.