This function never recalculates its results after the initial calculation. You have to delete and re-enter it each time you change the cells that it references. Others have reported this issue yet still give it 4 or 5 stars, which I don't understand, since that basically makes it useless. I haven't personally done any add-on development, but there should be a way to tell Google Sheets that the results of this function must be recalculated every time. Unfortunately, even if that were corrected, the add-on would be too slow for any serious use. If you reference an entire column, such as saying DDDREF("Sheet1", "Sheet2", "A:A"), it doesn't optimize for blank rows, so it takes a few seconds to run each time. Imagine that happening every time you enter a value...

A very useful tool, but sometimes I see the message: Error Unknown function: 'DDDREF'. Deleting the formula and ctrl + z didn't help. Sometimes I have to come back to it later to find the extension working.

Seems helpful but I get an "exceed max execution" time error when running it on a larger financial sheet. Seems like a great tool. I hope the dev continues work on this.

Love the add-on. I could be able to sum all the cells across the 3d range with the below formula. =sum(DDDREF("first";"last";"A1")) However, when the values in reference cells change, the DDDREF formula do not update accordingly. I need to delete the formula and ctrl+z to recalculate. It would be great if recalculation is performed. BEst regards,