2
votes
0answers
24 views

Twitter trends without hashtags

When looking at Twitter's trends one can find trends with hashtags: #NationalHugDay #danielholtzclaw But also without it: Nats Patrick Kane Why are there trends without a hashtag? How are they ...
2
votes
1answer
22 views

Google Sheets Conditional Formating “IsEqualTo” value in referenced cell

What do I add to the text field directly below the "is equal to" selection if I want the test to be the value of a specific cell? I want the condition to pass and format a cell "IF" it is equal to ...
2
votes
2answers
56 views

Lock the formula of a cell, even if the cells it references change

I have this, in D1: =sum(D3:D) I want D1 to always be the sum of the rest of column D (D2 is a header) I sometimes move a row, from eg 8 to 3, and that causes D1 to change to sum(d4:d). I want ...
1
vote
1answer
15 views

Can Cognito Forms calculate rental inventory availability by date and other variables across multiple form submissions?

I need to know if I can create a calculation(s) that will keep a running total across all form submissions of when certain products or services are selected on particular dates and allow me to create ...
2
votes
1answer
13 views

How do view Flickr.com using the OLD style, consistently & automatically?

I know there is a "secret" way to display pages from Flickr.com in the old style -- which the majority of old users preferred. How do I consistently and automatically view pages in this style?
2
votes
0answers
12 views

Is it possible to import cell data AND cell format from one Google sheet to another? [duplicate]

I'm trying to import data "and" formatting from one sheet to another. I'm using =importrange("docID", "sheetName!A1:A30") to get the data, but it doesn't get the format. Suggestions?
0
votes
1answer
22 views

Outlook.com auto-deletes Sent messages after 3 days

The problem: Outlook.com is automatically deleting Sent Mail messages from the Sent folder after three days. I want it to retain Sent messages until I choose to delete them. Background: This issue ...
1
vote
1answer
28 views

Convert text automatically in Google Spreadsheets.

Background: We have a list of data that we import into Google Spreadsheets from Wufoo.. The data is user generated (user inputs the information into the form). After importing the data into google ...
1
vote
1answer
18 views

How to reference a range of data in another workbook (not importing)?

In Google Sheets, how do I reference a range of data in another workbook (not importing)? I want to reference a range of data in another workbook. The only information I can find is for ImportRange() ...
2
votes
1answer
23 views

Variable GoogleFinance formula (Google Spreadsheets)

I have a question regarding a formula: =GoogleFinance("CURRENCY:(A2)EUR")*B2 The content of cell A2 = USD, the content of cell B2 = 60, so the formula should be translated as ...
1
vote
0answers
9 views

Is there a way to name Link attachments in Trello?

When I attach a few links to a card, it's not always easy to tell them apart. (I have to do so by reading the part of the url that's visible). It'd be great if I could name the link so it's more ...
0
votes
0answers
28 views

Easy way to create a survey with an image attached to each question?

I'm trying to create an online survey with where each question would be an image plus a textbox for the answer (the theme is "what do you call this thing"). I've started doing it in Google forms, ...
0
votes
0answers
8 views

Can the columns on Fieldbook be rearranged?

I've just got my invitation to Fieldbook today. I'm playing with it right now and I've created some sheets. I'm trying to change the order of the columns on some sheets but can't seem to do it via the ...
0
votes
2answers
35 views

How I resolve import html showing error N/A [closed]

N/A error showing on following query: =importhtml("http://www.barchart.com/commodityfutures/Cotton_%232_Futures/CT?search=CT*","table",1) and =Importhtml(A2,"table",1) Also table id is "dt1".
1
vote
1answer
31 views

Markdown formatting in Google Keep?

Is it possible to use Markdown formatting in Google Keep?
1
vote
0answers
25 views

YouTube offline videos captions not seen on playback

I have saved a YouTube video of 1.5 hrs after verifying that it has captions(Offline videos). However when I play the offline video with the captions on, it still doesn't show any captions. Please ...
2
votes
0answers
12 views

In Google Sheets is it possible to print to a custom paper size?

I have a spreadsheet that I'd like to print on a single 8.5" x 22" sheet of paper. This is not a standard paper size, but my printer can print on it. The Google Sheets print settings dialog only ...
0
votes
1answer
57 views

After removing label, where does email go in Gmail? [duplicate]

I filter an email to a folder and it has label of the folder when viewing it. After I remove the label, I assume it go to Inbox. But I can't find it in Inbox. Where is the email go? I can't find it in ...
1
vote
1answer
66 views

Getting values from other sheets with a custom function

I've defined the following function, and use it in sheet1: function myfcn (sheetname,rowstart,rows,columnstart,rows){ var sheet= SpreadsheetApp.getActiveSpreadsheet().getSheetByName(sheetname); ...
1
vote
1answer
21 views

Custom Google Spreadsheets shortcuts : move selected row(s) Up/Down/Top/End

As the title says, I do move rows a lot and the lack of default shortcut complicates things for me... The drag option isnt practical when I need to move some rows to the bottom of a huge sheet!! I ...
1
vote
1answer
28 views

Automatically record daily values in a new column

So I have this spreadsheet I use to control Content funnel. I've come up with a few formulas to use something else than a pivot table. But in order to get the trends and alarms I'm looking for, I need ...
1
vote
1answer
88 views

How to recover Gmail draft

I was working on an important email in Gmail over several days, on both my iPad and computer. When I look for it now, it's not there. I DID NOT DISCARD THE DRAFT. It's not anywhere in Gmail, not in ...
2
votes
1answer
40 views

Find a years-old comment in Facebook (given certain details)

So I'm trying to plan a vacation with my family, and I'm considering Belize (bear with me, I know this is not Travel.SE). I have "On This Day" turned on in Facebook, and coincidentally, on Monday, ...
0
votes
0answers
8 views

What happens if I add identical files on two PCs at the same time? [migrated]

I want to add my music collection to OneDrive, but my internet is pretty bad. My OneDrive is connected to my PC and my Laptop. If I added all the files to my PC and Laptop at the same time would it ...
0
votes
2answers
21 views

Add placeholder text to input/textarea fields on Cognito form

How I can add placeholder in my input/textarea fields?
2
votes
0answers
19 views
+50

Notify Trello action to different Slack channels

I enabled the Trello integration in Slack and I was able to create notifications that goes in a newly created #trello channel in Slack. But this channel receives the notification of actions performed ...
1
vote
2answers
20 views

How do I calculate the sum of 2 columns using the max from each row based on a condition?

I have data in two columns. I would like to sum the two columns (A and B) based on the max value in each row and a condition (c) indicating if the row should be included in the sum. Example: A B ...
1
vote
1answer
19 views

Two pages on Google+

How can I add second page in Google Plus? I have personal Google+ account and my company page, but I want to create next page about my hobby. How can I do this?
0
votes
0answers
30 views

Trello & Elegantt : how does Effective Start Date & Effective End Date works?

does someone understood how the Effective Start Date & Effective End Date works on Elegant from Trello ? I trying to use trello+ elegantt for planning generation. Overlay on trello seems to ...
-1
votes
0answers
7 views

Insert list of folders from Gdrive to table dynamically [migrated]

here's what I need help with: I am working with google scripts and want to retrieve a list of my folders from Google and dynamically insert them into a table with jquery. I already have the js code ...
2
votes
1answer
44 views

Facebook event recovery

How can I recover a Facebook event page that was accidentally deleted? I tried looking at my activity log and the event no longer appears there.
2
votes
1answer
19 views

How would I apply formatting to another cell based on whether another cell's date has passed or not?

I'm working on making a spreadsheet in Google Sheets, and I'm attempting to have a column of names and then a column of dates adjacent to it. I'd like to set up some sort of conditional formatting ...
-1
votes
0answers
7 views

How to access phpmyadmin of my ec2 server [closed]

I have installed all the necessary files on my EC2 server including phpMyAdmin. My question is, I don't know where to find my phpMyAdmin user interface ? Can anyone help.
1
vote
1answer
35 views

Change text in one cell by removing the parts entered in other cells

I want to know if there is a way to add multiple numbers with letters to one cell and each number/ letter get eliminated when that number gets placed in another cell. For example: cell b4 has: 4, ...
0
votes
1answer
68 views

How do I to set Gmail as default email program in Windows 10?

I use Gmail as my default email client. What do I have to do to have mailto:x@y.com open Gmail instead of opening the standard Windows email program?
1
vote
1answer
18 views

Limiting by date field availability on Cognito Form

I rent equipment on my Cognito form and I don't want customers to be able to rent equipment after midnight of the previous day. We need time to set up their rental. I know I can change the range ...
5
votes
4answers
428 views

Google Docs with PNGs now produce black image background in PDFs

Suddenly when I download a Google Doc as a PDF, the image PNGs come down with a black background. They used to be transparent. What has happened here? Can I change it back?
1
vote
1answer
16 views

The fastest way to hide all labels in Gmail?

Label is a great feature to organize mail messages in Gmail. Currently I have quite too many labels that I want to hide them all and display back one by one by my choices. My google search here is ...
3
votes
0answers
13 views

Adding a recurring event in Google Calendar doesn't save the entire series

I've created and published a recurring event in Google Calendar. However, if someone adds the event, they get only the upcoming event, not the entire recurring series. Is there a way I can make ...
1
vote
0answers
9 views

Users can't reset their passwords anymore on Google Apps?

I did incorrectly activate (and then deactivate) a third-party SSO on a Google Apps account (aka linked to a domain name). Now that the third-party SSO is deactivated, users can log again into their ...
2
votes
1answer
55 views

Can I signup with Facebook with custom domain email?

I am trying to use my site mail to signup with Facebook, like myname@example.com, but Facebook is reporting it as invalid mail. So, are we not allowed to use anything other than Gmail, Yahoo etc.?
1
vote
1answer
16 views

Update latest spend on Google Sheets based on Date dimension

I have a spreadsheet report -- used to monitor our marketing campaign reports. So my goal here is to be able to update a cell showing the our current spending as of yesterday. How can I go about ...
1
vote
1answer
13 views

Using Arrayformula to compute running decremented total, subtracting the previous cell

This doesn't seem like it should be difficult. I'm keeping a running decremented total owed, where each line may apply some payment against the outstanding debt. Basically: A: Outstanding Owed | ...
-1
votes
1answer
27 views

Selective IMAP emails to gmail. How?

I wish to select my new business emails (approx. fifteen) from my personal webmail account at BT Yahoo (with 9,000 emails) and transfer them to my new work gmail account without using forwarding. My ...
5
votes
2answers
55 views

In Google Sheets, how does one get a 12-hour time of day *without* an AM/PM indicator?

I am trying to display times in Google Sheets without an AM/PM indicator, but with 12-hour time (not 24-hour "military-style" time). I do not need the AM/PM indicator as it is redundant in my ...
0
votes
1answer
23 views

How to dynamically retrieve and display data based on input from google forms

To be very specific, let's say I have a google form where it asks you your name (text box) and how much do you like carrots, with a multiple choice prompt of "very much" and "I hate them!" After the ...
1
vote
1answer
18 views

How to convert or parse olson timestamp in google spreadsheet?

How do you convert 2016-03-05T08:30:00 to time in google spreadsheet? I would like to convert it to hh:mm:ss. Thanks.
-1
votes
0answers
8 views

Adding cells from two different books in google docs [duplicate]

I have 12 different books. jan2016database, feb2016database, march2016database...etc for the year each book has 9 different sheets all titled the same i need to add cell b5 from sheet "compared" in ...
1
vote
1answer
36 views

False-positive Google search results that come from inner website search tool

I would like to know if there exists a name and maybe explanation for a phenomenon described below: I type into Google (or other search engine) words "chicken quick recipes". I click the first ...
0
votes
0answers
4 views

How can I restrict a user to a specific item in the Wordpress Admin?

Background: I would like to restrict a specific user to just one item in the Wordpress Admin. In my example, the user should have full access to the News entry. All other entries should be hidden to ...

15 30 50 per page