referencing other worksheets in formulas in generated Excel reports
When you write a formula in a template that references another cell on the same sheet, it increments the row number on each new row that is added by a foreach loop.
It would be great if this worked the same way for formulas referencing other worksheets.
I am happy to report that this idea was reviewed and accepted for development. I will update this ticket again when this functionality has development started and a release date is clear.
Thank you for your idea.