Column B are dates, beginning from B2 e.g 29 Jul 2024 Column C are amounts, being from C2 e.g. $100.00 Row 1 are date week ranges beginning from D1 e.g. 29 Jul 2024 – 04 Aug 2024 What I’m trying to do is auto populate the future week range, with amount from C2, in which […]

So I have two sheets, Expenses and Tax Deductibles. The Expenses sheet has it’s data filled via a Google form where I track date of purchase, the category it fits, whether it’s tax deductible, etc. The “Is this tax deductible” column filled with “Yes” or “No” data. I want to take all the cells that have “Yes” and take all the data from those rows and populate the Tax Deductibles sheet with it.

How can i do something like this in google spreadsheets?

Does anyone know how to make recurring bills for a dynamic calendar on google sheets?

Does anyone know how to make recurring bills for a dynamic calendar on google sheets?

Does anyone know how to make recurring bills for a dynamic calendar on google sheets?

Trying to implement this into my google sheets document. I keep getting an ‘invalid argument’ message for line 8, ‘origin’. How do I fix this? Also, Google Sheets is not automatically calling this function. Is this because the function itself is not completing without errors?

I have a Google sheet with 4 columns.
Column A contains a date, columns B and D contain a value.

I’m trying to add values to Google Sheets via PHP API.
It seems to be easy to add ordered-based values, e.g.

I need to create a conditional formatting for several cells, each one of them based on another cell. E.g. B2 based on content of B3, C2 based on C3, etc. I know how to do it for one cell, but when I copy the format, the referenced cell is kept. E.g. if I create a conditional format for B2 based on content of B3, when I copy that format to C2, it keeps the rule based on B3, instead of C3. Is there a way to do this automatically? I need to apply it to hundreds of cells.