Questions tagged [google-sheets-formula]

Please refrain from relying solely on spreadsheets or images for data sharing. Instead, opt for markdown TEXT tables as a more effective alternative. If you have any Google Sheets-related queries regarding spreadsheet formulas, be sure to use this tag in conjunction with others such as [google-sheets], [array-formulas], [google-query-language], or [custom-functions]+[google-apps-script] when incorporating custom functions written in [google-apps-script]. Avoid using the tags [excel] and [excel-formulas].

The Appsheet algorithm determined the exact expiration date as 2 days from the specified date

In my Appsheet, I have two columns: Production Date and Expired Date. If the Production Date is 35 months before the Expired Date, how can I create a formula in Appsheet to calculate this? For example, if the Production Date is 01/10/2023, then the Expired ...

javascriptgoogle-apps-scriptgoogle-sheets-formulamobile-applicationgoogle-appsheet

Obtaining angel investor information through web scraping

Trying to extract data from the Angel.co startup list and save it in a spreadsheet. I have attempted various methods but keep running into errors, including using IMPORTXML and IMPORHTML functions in Google Sheets without success. The desired format for t ...

seleniumselenium-webdriverweb-scrapinggoogle-sheets-formula

Customize the appearance of your apps script using conditional formatting to highlight values that are

https://i.stack.imgur.com/L1KFZ.png I need to create an array of all 50 US states based on the abbreviations in a column. The goal is to compare each cell against the array and if it doesn't match, format it red. After researching conditional format ...

javascriptgoogle-apps-scriptgoogle-sheetsgoogle-sheets-formulaconditional-formatting