With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
Monday, June 17, 2013
yogi_Set Up Formula To Automatically Calculate Row by Row WeekDay Month And Day In Columns C D And E As Dates Are Entered In Column B
I've been reading several posts about auto copy, but they all use arrayformulas() and i'm not that advanced, so i'm going to ask my question a little differently.
Goal: Eliminate unnecessary formulas down the entire row, but rather have them auto copy when data in the first column is added to a new row.
Data: In my Sheets document i have the following:
COLUMN A - Manually entered date
COLUMN B - Formula (see below) would return the Day of the Week (i.e. Saturday)
I want the formula in B2 to auto copy to B3 if A3 contains any value other than 0
Is this even possible or am I completely over-complicating this?
Here is what you asked and my responses:
a) tell us what you need help with
I need help adding a formula or script that will auto-add formulas to the next row when a new date value is entered so that i can avoid unnecessary formulas all the way down the entire sheet. * (As a bonus, it would also be great to do the same thing with the validation cells whereby they are copied down as a new date is added. This would eliminate the grey down-arrows from populating all the way down the column.)
b) in which cell?
c) of which sheet?
d) show us your expected result along with needed logic/explanation
The expected result is not to have the formulas copied down the entire column.
The current formula is the noted columns is current and correct.