Categories
User Help Web Apps

How to make Google sheets refresh date filtered pivot tables when a day passes?

Google Sheets has a nice advantage over Excel – their pivot table automatically refresh, while Excel’s pivot tables rely on clicking a manual UI refresh button (or – if the right pivot setting is changed from its default state – by reopening the relevant file). But Google Sheets’ pivot tables do not get refreshed in […]

Categories
User Help Web Apps

Rename multiple files in google drive from a spreadsheet

I have this spreadsheet which contains the name of multple files in my google drive Column one contains the current names of the files and column two contains the new names i want to assign to each file Using google app script i could do this manually by copying the old names one after the […]

Categories
User Help Web Apps

Remove WhatsApp images from OneDrive photo library

I’m trying to remove WhatsApp clutter from my private photos folder on OneDrive. I’m using OneDrive on Android and it seems it is being used as the backup target for WhatsApp and Viber. I really need a suggestion on how to remove the whole WhatsApp lot from OneDrive and stop syncing new ones. If there […]

Categories
User Help Web Apps

How to format this result in google sheet as a table again after importxml of nested table?

I used this formula in google sheets =importxml("https://www.investing.com/equities/aboitiz-equity-balance-sheet","//tr") However, however it is a nested table, so the values are not formated pro Symbol Exchange Currency AEV Philippines PHP Delayed ABTZY OTC Markets USD Delayed Period Ending: 202030/09 202030/06 202031/03 201931/12 Total Current Assets 149486.88 157703.15 157060.05 124425.29 **" Cash and Short Term Investments 65403.14 75288.51 […]

Categories
User Help Web Apps

ImportHTML number of tables keeps changing

can someone help me? I use the google sheets importHTML function to scrap data from the website, but the number of tables keeps changing. How to set it so that it gets the correct table every time?

Categories
User Help Web Apps

Combine two separate, working queries

Trying to combine two separate, working queries, so both can be used on a single sheet. The idea is a User selects Data for a Resource (sheet TAB), and then either: a Region (Column D) or a County (Column H). Both Region and County are Drop Down lists. These are the Queries that work separately: […]

Categories
User Help Web Apps

How can gaps be quantified within a combined set of variable arrays?

I’m using Google Sheets to build a crop planning tool for farmers (kinda like a gantt chart). I need help quantifying the number of days within a given timeframe that no crops are planted in a bed. In the end, I want to be able to be able to reference a single bed by name […]

Categories
User Help Web Apps

How can gaps be quantified within a combined set of variable arrays?

I’m using Google Sheets to build a crop planning tool for farmers (kinda like a gantt chart). I need help quantifying the number of days within a given timeframe that no crops are planted in a bed. In the end, I want to be able to be able to reference a single bed by name […]

Categories
User Help Web Apps

How can gaps be quantified within a combined set of variable arrays?

I’m using Google Sheets to build a crop planning tool for farmers (kinda like a gantt chart). I need help quantifying the number of days within a given timeframe that no crops are planted in a bed. In the end, I want to be able to be able to reference a single bed by name […]

Categories
User Help Web Apps

Placeholders in a FROM Clause in SQL query. like in Python string Formating [closed]

select * , RANK() OVER (ORDER BY CAST(batchid AS INT) DESC) AS RNK FROM {0}.tablename I am new to coding and would like to where "0" holding the database name is {0} is supposed to be in my code. In python it is always in the ".format(….)" but this is a sql code and part […]