I noticed that when exporting a project or report to Google Sheets, any dates (e.g. start date, due date, created, last modified, etc.) render as a random(?) 5-digit number rather than a date format. However, the dates render correctly when exporting to .CSV format.
Please let me know if this is an error on my side! Thanks
Ashley
Usually, that 5-digit number is really a date, just formatted as an integer. You ought to be able to reformat it as a date within Google Sheets: Format/Number/Date.
Could you please tell me how you set up Google Sheets as a printer? I’d like to export a report to Google Sheets, however, I don’t have that as a “printer” option.
But then how to do sort those values in g-sheets, I format as Date, then do the sort range steps one does in G sheets, but it re-orders back to the integer value, I think. it’s difficult user expereince.