Hello,
I am working in google spreadsheets and need a few things to happen:
1.) Autofill 3 months worth of dates in relation to today's date in specific cells
2.) Automatically hide a column if the date in a specific cell is 30 days prior to today's date and 30 days after today's date
3.) On Open I need the sheet to open with today's date showing in the center (I already have excel auto highlighting today's date each time I open the doc.
4.) I want the sheet to show the data for any date (whether it's 3 months past or 2 weeks ahead) by me simply typing in that date into a certain cell. (This should allow me to reference any month or date even if those columns are already hidden)
Example of data is as follows:
https://docs.google.com/a/sgcmail.c...dT1qIMQDwdjUTIT-PKZjp7DhU/edit#gid=1448358985
Ask to get access to this document and I'll share it with you. It'll be easier if you can see the actual setup of my document.
It's sort of urgent I figure this out soon, if possible!! Thanks sooooo much
I am working in google spreadsheets and need a few things to happen:
1.) Autofill 3 months worth of dates in relation to today's date in specific cells
2.) Automatically hide a column if the date in a specific cell is 30 days prior to today's date and 30 days after today's date
3.) On Open I need the sheet to open with today's date showing in the center (I already have excel auto highlighting today's date each time I open the doc.
4.) I want the sheet to show the data for any date (whether it's 3 months past or 2 weeks ahead) by me simply typing in that date into a certain cell. (This should allow me to reference any month or date even if those columns are already hidden)
Example of data is as follows:
https://docs.google.com/a/sgcmail.c...dT1qIMQDwdjUTIT-PKZjp7DhU/edit#gid=1448358985
Ask to get access to this document and I'll share it with you. It'll be easier if you can see the actual setup of my document.
It's sort of urgent I figure this out soon, if possible!! Thanks sooooo much
