Is there a way to use the {r} marker in a dynamic way? Here’s what I’m trying to do and perhaps there is a much better way to do this.
In my designer sheet, I have a created a table so I can reference the data in a more readable format. So, my formula is using index to jump into the table. Since the table has a header row, the row index is the sheet row minus 1.
&=&=INDEX(Costing[Unit Quantity],{r})*INDEX(Costing[Bare Unit Cost],{r})*INDEX(Costing[Cost Multiplier],{r})
But when I use {r-1} it simply puts the text “r-1” in there.