I could do with your help on a tricky problem I’ve come across. It’s not really essential to my app but it’s a nice feature!
Essentially, I have a log where I record all transactions, and in a helper column I have a “Duplicate Check” formula to stop me entering the same transaction twice. It uses COUNTIFS. The issue I have is that if I put this formula in place, my transactions get added on as new rows below the bottom value of the helper column, meaning my helper column isn’t very helpful!
I have created a workaround where when a form is submitted it also submits a hidden column value that is the formula that I want to put in the helper column. Should work fine, except the only issue is that glide puts a ’ before the = of my formula, meaning the formula doesn’t actually calculate and is entered as text! Is there any way around this, or am I going to have to just do without?