You cant add a formula using the text entry field. It will be considered as text… You can use Google Scripts to read and set that text formula as an actual formula. Can you explain why you are trying to do that? You can use arrayformula to set formula for all rows in google sheets

No problem.
Problem I think I have though is that in google sheets its only displaying the number 0 after its been synced from glide after i input the formula mentioned above?

Can you describe more on what the formula is doing here, and do you absolutely need it in Sheets or working with Glide calculated columns would be better?

Hey! The formula is designed to search another sheet within the spreadsheet for relevant data and then return a numbered tally(result) to the cell. Can you explain more how I could do this with Glide calculations? Thanks in advance

You probably want a relation to match to the relevant records in your second table, and then a rollup through that relation to calculate a sum/total of matching records.

How do you define “relevant” in this case? (Looks to be something to do with Dates?)

If you can show screen shots of each of the two tables, we can probably give some more specific guidance.

Hey Darren! Thanks for the input Your solution definitely sounds like a great idea if it is possible. My formula searches for matching text in one column and then counts up all dates from the a specific month that the text has a record and then returns a total …. If that makes sense? I’ll do some googling on how to use the relationships feature in Glide. If you have any tips that would suit my case it would much appreciated. Thanks again

It kind of makes sense, but it would be much easier to visualise if you could show me a screen shot of what the data looks like, and point out the specific columns that need to be considered.

No the sheet your looking at is an automatic and live feed from our e-commerce store. The idea is our glide app will give us a total of the amount of times each specific coupon was used on a specific month …. If that makes sense?

Wow this is some wizardry thanks! Only one glitch I have is that for one of the months it is adding up all the times the coupon appears and not just for that month? Which is hard to understand because math column creates a unique number for each month? So I’m not sure what’s happening. Anyways I’ll keep tinkering and see if I can get to the bottom of it. Thanks again legend!