rtod2
asked on
Autopopulate columns upon time zone selection
Currently, the columns populate when a name is typed in. I want to change this so that the columns (D through G) populate when the time zone in column B is selected.
ASKER
I didn't know that. That makes it kludgy at best. Do you have any other suggestions? Is there not any way to have the default value C be 0?
ASKER
There is also some problem with the date values. Sure do wish there was a way to protect that. Your assistance is greatly appreciated sir.
ASKER
Problem with auto-population remains. Why can't column C auto-populate also with a default value of 0. Wouldn't that make the rest of them populate?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
OK, that works out alright. I know the app is limited. This sheet though needs to be shared so I couldn't do it in Excel. That is the nature of this project. Note that in this screenshot >>> http://screencast.com/t/zqvAo5tDmt , the scrolling usually shown to select from the list of the time zones is missing. I am using the latest version of Firefox which could be contributing to the problem. I notice that this only happens the first time you try to select a time zone. If you go back to it, then the scroll bar is there. Can that be fixed? I think we are almost home on this one.
This happens to me too. I don't think it's got anything to do with the browser but it is the google docs application that works that way. Not much you can do about that other than make a complaint in google docs support. I also tried it with the Google Chrome browser with the same results.
Cheers,
Curt
Cheers,
Curt
=if(B4="","",mid(text(now(
The formulas in E4-G4 have also been updated to IF(B4..... and likewise been copied down to row 100.
Note that you need to select values in both columns B and C before you see any values in D-F since both columns B and C are part of the calculations.
Curt