143 reputation
315
bio website google.com/profiles/…
location Louisville, KY
age 32
visits member for 4 years, 1 month
seen Oct 14 at 14:56

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.


Mar
27
comment Combine text from rows got by specified date in a Google Spreadsheet
Figured it out!
Mar
27
comment Combine text from rows got by specified date in a Google Spreadsheet
This looks like it fits the bill. You definitely get the bounty. However now that I am seeing the results I am wondering, is it difficult to append the amount to the note? See modified question.
Mar
1
comment Return text from multiple cells on another sheet with linefeed if dates match
To clarify I don't have extra notes in column to the right of the date. I have extra rows. It would look lite this in CSV Date,Note \n 3/2/14,"Note 1" \n 3/2/14,"Note 2" \n
Mar
1
comment Return text from multiple cells on another sheet with linefeed if dates match
What do you mean by this? Can you give me an example in your formula below?
Feb
25
comment Return text from multiple cells on another sheet with linefeed if dates match
That would actually be best. What change would I make for that?
Feb
25
comment Return text from multiple cells on another sheet with linefeed if dates match
I don't need to support that. If it occurs I would just want the first or last. See 2nd paragraph.
Jan
18
comment Arrayformula with dates before and after
I have to wait 24 hours to award this. Awesome!
Jan
18
comment Arrayformula with dates before and after
Perfect! I think I will let the bounty end so I can award more. I don't really have experience with this bounty stuff so if you think that won't work I will accept now.
Jan
13
comment Arrayformula with dates before and after
greatly clarified my description in SE here and my expected output was all messed up. It should make sense now. @JacobJanTuinstra
Jan
12
comment Arrayformula with dates before and after
I added the doc you wanted to see. @JacobJanTuinstra
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.
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
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.
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=...
Feb
15
comment how do I add isblank(ref) criteria to arrayformula?
Not sure what you mean. Added comments to spreadsheet to explain.
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.
Feb
12
comment how do I add isblank(ref) criteria to arrayformula?
Not sure I understand your comment. I want to know how much need to be in each account on each day. As payments post I want to add the date and have the action of adding that date cause the amount due to be removed from the list.
Feb
11
comment how do I add isblank(ref) criteria to arrayformula?
This is really good. It almost does what I want. There are some odd things about it. The biggest problem is that all totals disappear when B3:B is blank. I like the way it eliminates dates where nothing is due.
Feb
7
comment Resend email to unresponded in SurveyMonkey
Here is some googled information on resending surveys for partial completion. May or may not help.