In Google Drive Sheets you can use the custom header and footer tool to add custom headers and footers when you export a spreadsheet as a PDF.
I would really like to get into the footer a statement like this :
- (psuedo code)
Page - $PageNumber of $PageCount
which would output something like :
- "Page 1 of 4".
Im aware that you can get a Page Number in there, but is there anyway i can do the above ?