Gemini in sheets is not that hot yet, but I think it's got hancuffs on to prevent people destroying their valuable work product.

But if I ask Gemini to build be formulas and than just paste them into Google Sheets the results are pretty darn good.