Formula Repeater

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.

Nevermind … {r}-1 … wasn’t thinking.

@ghandlin,

Good to know that your issue is sorted out. Feel free to contact us any time if you need further help or have some other issue or queries, we will be happy to assist you soon.