#google-spreadsheets

How-to: How to avoid selecting a cell address when using the arrow keys while editing a cell #answer #it #dev

How to avoid selecting a cell address when using the arrow keys while editing a cell

Sometimes, while editing the contents of a cell, using the arrow keys will not move the cursor but instead inserts the address to an adjacent cell.

Here is an example of this problem with a screenshot: I go into an empty cell and enter =SUMIF( and then decide I want to use a normal SUM instead of a SUMIFso I hit…

How to: Cell concatenation by hotkeys rather than a formula #computers #answer #solution

Cell concatenation by hotkeys rather than a formula

In my fumble-fingered attempt to copy (supposedly with Ctrl+c) part of a column containing a few text strings in individual cells within new Google Sheets, on pasting (supposedly withCtrl+v) I ended up with the required text strings but all together in the one cell (no spaces) rather than in the same columnar format I started with. The result is…

How to: Adding particular data to particular sheets within one document #development #fix #computers

Adding particular data to particular sheets within one document

I am a bit new at this and am having a tough time getting this to work…

I have multiple sheets, one main one (Submissions) which receives data from a form, then I have the sheets: Level 1, Level 2, Level 3, Level 4, Level 5

When data (all text, into B:B) is received, I grade it manually with a number in C:C, still all within…

How-to: Duplicate then concatenate in Google Spreadsheets #dev #computers #development

Duplicate then concatenate in Google Spreadsheets

How do I join a to both sides of : to result in a:a?

I could use something like =join(":","a","a"), but in this case, my "a" is another formula and it is very long. I’m trying to find a way so I don’t have to write the formula twice.

Something like

=join(":",rept("a",2)) → but this produces aa

Answer [by Jacob Jan Tuinstra]: Duplicate then…

Answer: I can't seem to be able to use Google LaTex integration #dev #computers #programming

I can’t seem to be able to use Google LaTex integration

Google claims that they have allowed LaTex equations in Google Docs. According to the help page, the option should appear under Insert → Equation. Doesn’t seem to be the case:

So what am I doing wrong?

Answer [by Alex]: I can’t seem to be able to use Google LaTex integration

That’s because the respective help page is referring to Google D…

Solution: Pre-fill field with formula — incremental counter — in Google fo rm #answer #programming #computers

Pre-fill field with formula — incremental counter — in Google form

I have a Google Docs form that I use to track my customers complaints. Is it possible to have a “counter” field pre-fill with an incremental number? I want my customers to have a complaints number when I’m talking with them.

Original post

Fixed: Google-speadsheet data validation to restrict to Mondays only #computers #answer #fix

Google-speadsheet data validation to restrict to Mondays only

I have a field in Google Sheets I labeled “Week of”. I want to restrict user input to a date (mm/dd/yyyy) which is a Monday. I can set “Data validation” -> “criteria” to “Date” but how do I limit it further?

Answer [by pnuts]: Google-speadsheet data validation to restrict to Mondays only

Please try a Custom formula is of :

=weekday(A…

Fix: Appearance of Forms I never created in Google Drive #dev #fix #development

Appearance of Forms I never created in Google Drive

I have some Google Sheets file which I copy and change monthly. I never used Forms, but they are appearing all the time in the Drive and are related to this G.Sheets file as you can see on the screenshot –

Could you please explain why does it happen? How can I stop this behaviour? How can I use this auto-creatiion (the goal)??

Original post