This might already be something the plugin can do. I might just not be getting the formatting correct, but it wouldn't seem to be mentioned anywhere in the docs. The example I have is for making an invoice. I'd like a cell to show the pre-tax subtotal of the items in the invoice, then a cell below that calculating the tax, then a cell below that showing the total. I tried to achieve this with variations of @>-2$2 for example. The work around is just hard coding the specific cells, which is not the end of the world, but it would be really nice to have a generic formula I can include in my template for my invoices.
This might already be something the plugin can do. I might just not be getting the formatting correct, but it wouldn't seem to be mentioned anywhere in the docs. The example I have is for making an invoice. I'd like a cell to show the pre-tax subtotal of the items in the invoice, then a cell below that calculating the tax, then a cell below that showing the total. I tried to achieve this with variations of
@>-2$2
for example. The work around is just hard coding the specific cells, which is not the end of the world, but it would be really nice to have a generic formula I can include in my template for my invoices.Any help would be greatly appreciated.