Sheet property information?

Eric B.

I just ran out of cells in a sheet and needed to fire fight to recover some data that pours in via an automation. Generally I don't need to create a new sheet until year end each year, but this year saw an uptick in line items.

Is there a way to collect high level property information from a sheet?I was envisioning something like this that could contain populated cell count, unpopulated cell count, number of columns, file location, file size, relevant date information…. etc.

ie. Right Mouse button on a file, Properties: