Are you using arrayformulas anywhere? Is data writing to the very bottom of your google sheet?
Are you attemping to write any data from glide into the sheet with the query/unique formulas?
When you click on Reload in the glide editor, does it pull in data from the sheet?
Are you using google forms??? If so, why not a form in the app?
I’m using glide forms, the problem might be that the unique function formula is where the value is going to be? so maybe glide doesn’t see a value but a formula?
I’m new to sheets so I don’t know if that’s normal or not.
Some cells in sheets are darker grey, what does that mean?
Not sure I follow, but you shouldn’t be writing to the sheet that’s dynamically built from a formula. If I understand your use of Unique, it’s to build a list of unique categories of some sort. This should be in it’s own sheet. Any form data should be written to your original sheet and the sheet with the formula will build off of that data.
Glide will only interpret the visible data on that sheet that’s built from a formula. It does not see formulas that are used in the sheet.
Darker cells google sheets probably mean that the colors were set somehow. Possibly by you. I don’t think glide can set cell formatting/colors in the google sheet.
If you have any screenshots or videos to help explain what kind of problem you are having, that would help a lot. Otherwise it’s hard to understand what you are doing or expecting it to do, or what’s not working as expected.