All Questions

6,095 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
-1
votes
1answer
65 views

INDEX(GoogleFinance(“USDIDR”, “PRICE”, F530),2,2) F530 = cell with date

INDEX(GoogleFinance("USDIDR", "PRICE", F530),2,2) F530 = cell with date (formatted to date), please help, how to apply above formula for stock listed in Indian markets ( NSE or BSE)?
-1
votes
1answer
78 views

Count times user won where user is in team

I have a list of teams with a list of players next to it (Would it be better/easier if the players are in a single cell?) +Team Name+--------+--------+ | Team 1 |Player 1|Player 2| | Team 2 |...
-1
votes
1answer
101 views

Apply the conditional formatting formulas across every column of the sheet

I've got a Google Sheet that I'm trying to write some formulas for - it's basically just a bunch of numbers in columns that I'm trying to do some conditional formatting on (per column). I want to be ...
-1
votes
2answers
2k views

I got this “Error: Imported content is empty”

I am trying to create a google sheet to combine some information. I want the sheet to pull information h index of my friend this is the code =IMPORTXML("https://www.scopus.com/authid/detail.uri?...
-1
votes
1answer
59 views

How to pull an exchange rate price on Poloniex to google spreadsheet

I have a Google spreadsheet where I compute my earnings based on the exchange rate of an exchange, specifically Poloniex.com. Atm, I manually check the rates on the website and enter it manually on my ...
-1
votes
1answer
5k views

How to see deleted comments in a Facebook group

Is there a way for a Facebook group moderator/admin to see deleted comments or deleted posts?
-1
votes
1answer
47 views

all email addresses of file FileA is added to the group email called test@test.de

I would like to modify the following script so that all email addresses of a column google drive file called Finance is added to the group email called test@test.de. How should I change the script? ...
-1
votes
1answer
445 views

Will I be able to get retweet/likes notifications from ones who turn off my retweet?

I'm conscious that, if ones turn off my retweets, will I be able to get the the notification if they still retweet me, like if they still follow my twitter account or if they added me to their list.
-1
votes
1answer
52 views

Prefill data from multi page form to another multi page form

How to prefill form data from a multi page form to another multi page form?
-1
votes
1answer
37 views

Changing page name and bots: was anyone able to talk with a real person?

We have wasted a lot of time trying to change the page name. We have attached evidence that the mark is ours and the denunciation that prevents us from continuing to use the current name, and the ...
-1
votes
1answer
32 views

Rename uploaded file as per entry id

For Cognito Forms, Is it possible to rename file uploaded automatically as per the id of the entry or formating it some how?
-1
votes
1answer
88 views

Leave blank combined with IF data entry

I'd like the following scenario resolved if possible. I have the following formula; =if(B3>C3,"3",if(B3<C3,"0",if(B3=C3,"1"))) So that the result of football matches enters either 3, 1 or 0 ...
-1
votes
1answer
63 views

One email address keeps subscribing to the same list over and over and over again. What can I do?

I've set up a mailing list, but one specific email address / user keeps subscribing to this specific list, over and over and over again. It's been going on for 7 months now. How can I blacklist them ...
-1
votes
1answer
603 views

How to quote formula result?

I have a function which returns a URL from hyperlink as a first parameter to IMPORTXML function. For the function to work I need to put the output of that function in quotes, how do I do it?
-1
votes
2answers
357 views

Sum certain numbers in a range of cells that contain text and numbers

I've got a range of cells in Google Sheets that contain a mixture of text and numbers, or just text, or even blank cells. For example: Yes 32 Yes 46 Yes No 1 No Apologies 23 Apologies n/a (and blank ...
-1
votes
1answer
47 views

With a common Gmail ID for a group of users will people signing in from different locations at the same time be blocked?

If I create a common Gmail ID for a group of users (about 100) for a specific purpose (like sharing PDFs) will it block people from signing in, if they are logging in from different locations and ...
-1
votes
1answer
43 views

Filter but maintain duplicates

I am trying to filter a one larger range from a smaller range. The master range has duplicate entries, however, so when I try to filter from it, it pulls out all duplicates when I'd rather have it ...
-1
votes
1answer
22 views

Why can't I see section B when it appears to be just like sections A and C?

I'm adding sections (not repeating) to my form. I have 3 sections: A, B, C The section name for A and C show up when I click on a field within that section and create a condition for when it will be ...
-1
votes
1answer
53 views

Would Google Sheets LOOKUP recognize 0-50 as 0 through 50?

I was wondering the possibility of an answer to the question in my title. The formula I have is: =LOOKUP(A1, E1:E3, F1:F3) Here, A1 can be any value from say 0 to 1000. E1:E3 contain ...
-1
votes
1answer
49 views

Copy and paste between forms

Is there a way to copy a form field and associated content from one form to another?
-1
votes
1answer
84 views

Is there a way to rearrange columns of repeating sections in the exported CSV file?

I am using Cognito Forms to gather information about my worker's work progress for client billing purposes. They submit one form a day, but each work assignment gets filled out in a repeating section. ...
-1
votes
1answer
199 views

I have two Google accounts, how to verify they are NOT LINKED

I opened a second Google account so I could make a business page years ago. The owner did not believe in social media. But I had a vision and did it. I no longer work there. They want the ...
-1
votes
1answer
95 views

Is there a way to get a confirmation email with a PDF file of a form to the person who completes the form?

My employees will be submitting forms but they may also need to print out the form that they complete. How can this happen?
-1
votes
1answer
328 views

Transposing with header row

In Google Sheets I'm trying to transpose a list of items in rows to display as columns. I am looking for a way to transpose the Category field to act as a header row that extends over all the items of ...
-1
votes
1answer
64 views

Formula for: Run INDEX - Search it for several specified strings - replace them with specified strings

Here is a sample spreadsheet I threw together that shows more or less what I'm working with. I have two sets of two similar formulas that produce INDEX outputs from the same set of data. The first ...
-1
votes
1answer
171 views

Split varying number of columns of one row into multiple rows?

Reading the related question Split content of one row into multiple rows? thought you might be able to steer me in the right direction. I am working with data in Google Sheets that I would like to ...
-1
votes
1answer
36 views

Is there a way to have the actual document(s) inserted in place of the file name(s)?

I would like to have the uploaded files included in the PDF. Currently only the name of the file is included.
-1
votes
3answers
116 views

How to set visibility of Facebook profile likes

How can I setup the visibility of profile photo likes? For example when anyone does not have me in friends, he can´t give me like and I want to anybody can give me like even if he hasn't me in friends....
-1
votes
1answer
76 views

Is there a way to reset to a blank form after submission automatically?

I have a form embedded on my website and I want the ability to have a new form (same form) be filled and submitted multiple times if needed without having to refresh the webpage.
-1
votes
1answer
405 views

Google Apps Script for converting military Timestamp into 12-Hr in Forms submissions?

Has anyone created a script to use in Google Forms/Sheets to convert or display the military time to 12-hour instead once the form has been submitted by a user?
-1
votes
1answer
159 views

How can I calculate the number of minutes?

I have a form with two date fields and two time fields for a timesheet, and want to calculate the number of minutes between. If a job starts in the evening and ends in the morning, how can I calculate ...
-1
votes
1answer
145 views

Redirected URL Submit to new window?

Is it possible to make a redirect URL submit click open in a new window?
-1
votes
1answer
53 views

Do I need an SSL certificate?

Do I need an SSL certificate for my website if I'm using Cognito Forms? My media person is trying to sell me an SSL certificate as Google is going to mark HTML pages with forms as "insecure", but I'm ...
-1
votes
1answer
209 views

Client Side Events

I'm new at JS (and Stack Exchange) but would love to learn more about the lifecycle of my forms, specifically the multipage activity. I've checked out this page https://www.cognitoforms.com/support/...
-1
votes
1answer
1k views

Turn Facebook place into page

Few years ago someone created Facebook "place" of our company. It's wrong. Now we want to remove it from "places" and keep it as a normal "page". There are two same manuals how to do that, one of them ...
-1
votes
1answer
40 views

Restrict each email address or mobile number to ONE sign up only

Can the email address or the mobile number that sign up user used to register be restricted to SINGLE use? (ie the same mobile number or email address cannot be registered TWICE in same form.)
-1
votes
1answer
42 views

Reset calculations

I've set up a form to choose either hotel or camping using radio buttons. I then have a dropdown that appears asking how many rooms are required or camping pitches, depending on what radio button is ...
-1
votes
2answers
132 views

Text Characters Calculation

How to calculate numbers of characters in a text box, and to make sure it is not lesser than or greater than a specific amount of numbers?
-1
votes
1answer
45 views

Possible to edit 'Amount Due'?

Is it possible to change 'Amount Due' on the payment to 'Total Cost'? I'm trying to use it so people can work out the total cost of different services, so Total Due doesn't really fit.
-1
votes
1answer
47 views

How to add a signature above post content in Blogspot?

I have searched this in google, but only finds how to add signature below the post content. I want it to appear on the post page and not on the home page. So how to do that?
-1
votes
1answer
137 views

If contains, countifs?

Is there a formula which would allow me to automatically put the answer in the place where it says *answer here * ? For example it analyzes column 2 to see where the Y which would be row 2 and thus ...
-1
votes
1answer
35 views

Authorize payment, collect after

We are looking to use Cognito Forms for online sales, however, instead of collecting the money through Stripe immediately we would like to authorize the payment using Stripe when they submit the form ...
-1
votes
1answer
699 views

What does “&q=%s” mean at the end of a Google search URL?

What does the &q=%s mean (and do) at the end of a Google custom search URL like http://www.google.com/search?q=@@@&tbs=qdr:y&q=%s? Background: I'm using Anysearch Safari Extension (https:/...
-1
votes
1answer
3k views

Conditional formatting with multiple criteria over a range of cells

There is another thread about this but all of the answers there aren't helping. In the range: D12:AY500 - I have a matrix of numbers such that: y=Date, x=Time: .. I would like it so the cells ...
-1
votes
1answer
47 views

Log in form for site

I am looking for a form to use for users to login to a site. Is there a form that can be used as a log-in to a site?
-1
votes
1answer
216 views

Cannot log in to Facebook Account - No way to contact support

So I can't log in to Facebook and have no way of contacting Facebook support for help - I'm developing a Facebook app using calls to their API for a job/interview test. So, I created the app on my ...
-1
votes
1answer
252 views

Instagram is hacked

Someone has hacked my Instagram account neither my username exist now neither my phone number or my email is getting connected. I tried Facebook it says account does not exist what should I do?
-1
votes
1answer
287 views

Google Spreadsheets formula should I use for highlight more than an 1hour passed between cells?

I need help with a Google spreadsheet formula. This is what I'm trying to do: Highlight the cells in “Conditional Formatting” where the time spent between 2 cells is more than 60min. In this case ...
-1
votes
1answer
136 views

Insert new cell into column B and “shift down” values every-time cell A1 changes in Google Sheets

I'm using Google sheets. I need to automatically add a cell above the existing B1 and shift the values down every-time the value in cell A1 changes. Column "A" is being populated by a google form. ...
-1
votes
1answer
30 views

How to fill out the form with desired time rather than time selected from the chart?

I am trying to have the time so that the people who fill out the form can just type the time they want, not select from the chart. How do I do this?

15 30 50 per page