Tag: google-sheets-formula

How do I change my formula syntax to use variables

I’m trying to use set formula but it keeps saying I’m having an issue with my syntax but I’m not exactly sure how to fix it. I’m trying to use declared variables as the inputs to the formula. The bold …

Find Google Sheets that matches a value in a cell of a sheet and execute a piece of code

I am sorry for this hideouts looking question but I have to ask. So bare with me. I am using google app script and trying to achieve following. I have two google spreadsheet books. 1.) Book A has only …

How to make Google Sheet drop down value affect other drop down

I have 4 drop downs with TRUE or FALSE options. I am looking to make a formula that makes it so that if one of them is true the rest is set to false automatically. So, in this case since Next Day is …