110 reputation
313
bio website google.com/profiles/…
location Louisville, KY
age 32
visits member for 3 years, 7 months
seen Apr 9 at 20:26

I try to be lazy/efficient so: lazfish. Get it? As described here

My website url link points to my Google+ profile if you want to know more.


Jan
10
revised Arrayformula with dates before and after
Added my awesome budget
Jan
10
asked Arrayformula with dates before and after
Dec
12
accepted how do I add isblank(ref) criteria to arrayformula?
Dec
9
comment How do I configure Dropbox to automatically delete the pictures from my phone that have already been uploaded via camera upload?
It really is insane that nobody has come up with a way to automatically delete photos from the iphone once they are backed up to icloud or dropbox. When my wife wants to take any pictures on her iPhone 4 we have to switch back and forth between dropbox and camera roll, manually comparing photos one-by-one until she has room to snap a few more. It is a constant job. - posting this as its own question and asking lifehacker.
Dec
4
awarded  Caucus
Dec
4
awarded  Constituent
Aug
12
awarded  Notable Question
Jun
7
revised google spreadsheets timesheet calculations
added 168 characters in body
Jun
7
comment google spreadsheets timesheet calculations
Nailed it! I am going to update my example when we are done and make it a blank sheet anyone can steal for their own abuse. What it currently doesn't show is the calculation breaking down each bi-weekly pay period.
Jun
7
accepted google spreadsheets timesheet calculations
Jun
7
comment google spreadsheets timesheet calculations
And good catch on the fix!
Jun
4
comment google spreadsheets timesheet calculations
Fantastic solution. Array Formulas are so powerful. Added a little conditional formatting so both text and background are white if is equal to 0 and this is perfect.
Jun
3
asked google spreadsheets timesheet calculations
May
29
awarded  Popular Question
May
8
awarded  Popular Question
Mar
7
comment Show availability/busy status across multiple Google calendars
turns out that whenever you have more than 1 it forces you to htmlembed. Also you can add a title by starting it with ?title=Title%20Here&src=...
Mar
7
answered Show availability/busy status across multiple Google calendars
Feb
15
comment how do I add isblank(ref) criteria to arrayformula?
Not sure what you mean. Added comments to spreadsheet to explain.
Feb
13
awarded  Informed
Feb
12
comment how do I add isblank(ref) criteria to arrayformula?
Yes. This is exactly what I want and is better than my solution in every way except that All amounts should show when no dates are entered. Currently no amounts show if I remove all text from column B.