All Questions

Filter by
Sorted by
Tagged with
-1
votes
1answer
87 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
2answers
131 views

Using Calculated Values in Math Functions

I need to perform a basic "X to the power of Y" calculation. The calculation builder doesn't accept the ^ character as an operator, so it seems I need to use the Math.Pow(x,y) function. That would ...
-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
588 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
353 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
46 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
2answers
401 views

How to use relative references in an ARRAYFORMULA with DSUM

I have a formula: Total Hours: =DSUM(data!A1:B, "Number of Hours", {"Provider Name";A2}) The column A is a dynamic list of all the providers. How do I use an array formula to fill in all the rows ...
-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
21 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
52 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
79 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
90 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
321 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
169 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
114 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
69 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
374 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
149 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
144 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
159 views

Disable icons floating by on live video?

Is there a way to disable these silly icons that float by when watching a live video on Facebook?
-1
votes
1answer
52 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
1k views

How can I protect an Apps Script with triggers and authorizations in a shared Google Sheet? [duplicate]

I have a Google Sheet that is shared via URL. It's a list of events. I wrote a script that syncs the list to a shared Google Calendar. The script has an installable on-edit trigger to update the ...
-1
votes
1answer
194 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
39 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
444 views

Query a column where numbers are mixed with blanks

I have a query where in a column there are numbers and blanks. It seems that the query function is treating everything in the column as string and not numbers. So when I sort, it doesn't sort ...
-1
votes
1answer
41 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
131 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
34 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
644 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
46 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
2answers
612 views

How can I search case sensitive online [duplicate]

I'm trying to search online for the string toUri(). Valid result will be Java's Path.toUri() But when I search google it return mostly toURI results. When I search I discover that search engines ...
-1
votes
1answer
213 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
248 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
276 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
130 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
40 views

How do I find a product name from a product key?

How do I get individual labels (names) for different products keys? I want to detect the product key and based on that assign the right product name to it. If it was just one product key in question,...
-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?
-1
votes
1answer
33 views

Move entry from one form to another

I have a couple of forms where I'd like to consolidate the entries into one. How can I move an entry on one form to another?
-1
votes
1answer
828 views

I turned my spam filter off in Gmail. How do I turn it back on?

When I search Google it only shows how to turn it off.
-1
votes
1answer
305 views

Date difference calculation

I'm looking to find out what formula to use to calculate the difference between two dates and display it in number of days, months, and years elapsed. For example: Today's Date: 6/2/2017 Date of ...
-1
votes
1answer
93 views

Why does Gmail send email from my server to spam?

Gmail sends email originating from my server to spam. I have only sent email to myself. rDNS is setup, SSL encryption is setup. Gmail says: It contains content that's typically used in spam ...

15 30 50 per page