Categories
User Help Web Apps

Link chart heading to cell

I would like the main heading of a Google Sheets chart to change dynamically by linking it to the value of a cell. The header input field does however not seem to handle formulas like =I4, it just displays the formula. Is there a way to link a chart heading to a cell value?

Categories
User Help Web Apps

Google sheets, how do I combine data from two cells, where there is a URL (web-link) in the cells, without loosing the link(url)

I have tried to write a custom function in google sheets. I tried to create a function to joint the content of two cells. It works for text, however it does not work if the text contains a web-link (URL). The link is removed. The code function combine(…theArgs) { var result =””; var is_first = […]

Categories
User Help Web Apps

Google Sheets – Get unique values from a column and return the values a single column

I was hoping to get some help and direction. I have two sheets–a ‘Raw data’ sheet and a ‘Dashboard’ sheet. A user would dump the raw data in the first sheet and the dashboard will summarise figures automatically (built some scripts for it). In the ‘Raw Data’ sheet, there is a column for Teams which […]

Categories
User Help Web Apps

How to create a dataset for Deep Learning project?

I am new to deep learning. I have taken a few courses on the same. I have a doubt in order to create a dataset, the examples I have seen so far, many of the researchers have used H5py/HDF5 file to create the datasets. Can anyone suggest to me how should I proceed? Can we […]

Categories
User Help Web Apps

Convert columns of ISO 8601 strings to dates in Google Sheets

I’m pulling data to my sheet from an API using an ImportJSON function. The data array contains mixed data, including several columns of ISO 8601 date strings in UTC. For example: 2020-06-02T00:00:00Z 2020-06-02T03:00:00Z 2020-06-02T14:30:00Z Google Sheets doesn’t apparently recognize these as dates, or at least applying a date format to these columns doesn’t do anything. […]

Categories
User Help Web Apps

DuckDuckGo finds one result which does not seem to contain the string I searched for

I wanted to search the web for OSTREAM_OPERATOR_OVERLOAD_FOR_FL_USTRING_IS_DEPRECATED, so I did it with Google obtaining no results, and then with DuckDuckGo, obtaining only one result, where the string I searched for is not in the page. Where has DuckDuckGo found that string?

Categories
User Help Web Apps

Create a custom DateTimePicker in Google Sheets

In a sheet I have a column to enter a datetime value that would later be checked by a script to create a trigger. I would like to set a picker in that column to ease selection and avoid errors. I know Google Sheets offers an option in Data Validation for date but not for […]

Categories
User Help Web Apps

ImportRange in Google Spreadsheets returns error despite

I’ve a formula with approximately 40 ImportRanges that fetches data from other tables. That formula is repeated 1166 times. The problem is that the ImportRange stops fetching data somewhere in the middle. It could’ve been the ImportRange limit, but the whole thing already worked in the existing spritesheet. When I moved all sheets with that […]

Categories
User Help Web Apps

How to reduce a google search URL to an anonymized version

If I enter a search term in DuckDuckGo I get a pretty simple url and query string https://duckduckgo.com/?q=python+tips&atb=v1-1&ia=videos&iax=web If I do the same in google I get a boatload of query string bloat, which I’ve anonymized with characters X, Y, Z, and K. https://www.google.com/search?sxsrf=XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX&source=hp&ei=YYYYYYYYYYYYYYYYYYYYYYY&q=python+tips&oq=python+tips&gs_lcp=ZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZ&sclient=psy-ab&ved=KKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKK&uact=5 If I just pasted a search result url generated by google […]

Categories
User Help Web Apps

Can automatic send emails when checkbox = True?

I’m looking for an script can automatic send emails when checkbox is True. This is my format example: What i want is when im clicking on checkbox = True at F2, i can recieve an email with excactly contents from A2 to E2, looks like this: Email subject= [Approved] Form Email message= contents below Timestamp: […]