Reputation
10,010
Next privilege 15,000 Rep.
Protect questions
Badges
7 28 75
Newest
 Revival
Impact
~863k people reached

May
22
comment How to calculate a date in Google Documents
Hey JJ and welcome to Web Applications. I saw your post already on the Google+ community and thus removed the hash-tags !! Stick-a-round as it might take a bit.
May
20
comment Multiply cell value depending on keyword
Why the excel tag?
May
19
comment Custom script “invoked too many times” error
@Rubén See developers.google.com/apps-script/guides/services/… and you will see that this is not related to the post you mention.
May
16
comment Is there an email service that allows you to use mutiple aliases?
While this link may answer the question, it is better to include the essential parts of the answer here and provide the link for reference. Link-only answers can become invalid if the linked page changes.
May
14
comment How to automatically increase the exponent in Google Spreadsheet?
Add this to your first line and you won't have to drag down: =ARRAYFORMULA(100 * POWER(1.01, ROW(C1:C4)-1))
May
14
comment Formula for smart, scale-aware number-formatting in Google Sheets? (e.g. 1,024 → 1k, 1,816,724 → 1.8M)
+1; That's a wonderful solution !!
May
1
comment In Google Sheets, can you apply a regex to a generated range?
For the postal code, wouldnt (LEFT(A1, 2) suffice?
Apr
30
comment Turn a table into a list of row/column/value tuples
Get out-a-here, +1.
Apr
29
comment Turn a table into a list of row/column/value tuples
Perhaps this answer is of use: webapps.stackexchange.com/a/40060/29140
Apr
29
comment How to delete a contact in Quip?
While this link may answer the question, it is better to include the essential parts of the answer here and provide the link for reference. Link-only answers can become invalid if the linked page changes.
Apr
26
comment For every occurence of x insert a new row beneath it
Why don't you share a doc with us?
Apr
24
comment Current date as a variable in Google Docs?
Does that mean it is not possible?
Apr
24
comment Current date as a variable in Google Docs?
Of course, good suggestion, but that's not the answer we're looking for. Read our help center or take the tour to understand why. Welcome on Web Applications !!
Apr
23
comment Find and replace text in Google spreadsheet
But this doesn't leave: Membership and Volunteer Crew ::: Sauna Crew ::: Crafters Crew, it only replaces the -| for :::.
Apr
21
comment Google Query For Dates in Last 30 Days
@JustinHandley This worked for me: =QUERY('VR Platinum'!A:N, "SELECT * WHERE A='Exited Positions Bullish Stocks' AND G >= date '" & TEXT(NOW()-30, "yyyy-MM-dd") & "' ")
Apr
19
comment How to limit the length of data in a cell in Google Sheets?
Not while entering. Upon leaving it is possible.
Apr
18
comment Google Spreadsheets: Identifying and Working with Any Cells that Match
If you add the essentials into your answer, this would be a great post.
Apr
18
comment Is there a way to include a “new…” option in a drop down list?
I'm sure you're talking about the Google Spreadsheet, not?
Apr
17
comment Google Spreadsheet Time of Edit
Have you tried this one: webapps.stackexchange.com/a/58308/29140
Apr
17
comment How to add line breaks in a cell before specific keywords in Google Sheets
Hear hear for Google Apps Script.....and Jerry101 !!