{{equals}} with dynamic reference in loop

Documents
1

when I have a table column with formula '=F1/12' then next rows will be '=F2/12', '=F3/12' etc what is correct

But if I have '{{equals}}F1/{{someValue}}' then every new row will have save reference ''=F1/12'

2

Hello @davrans,

Please share an example of the template, the JSON and the expected result. I'll do some tests and advise further steps.

Best regards,
Petr
Plumsail team

3 
{
      "users": [
    {
      "name": "John",
      "annualSalary": 100000
    },
    {
      "name": "Smith",
      "annualSalary": 50000
    }
      ]
    }

issue (3).xlsx (8.6 KB)
it's just an example, so pls don't advice to replace "{{equals}}" with "="

expected result -
for John Month salary is calculated by =B2/12
for Smith =B3/12

BUT both of them have =B2/12. Quarter salary column works as expected

4

@Petr would really appreciate your help cuz many of formulas are broken due to this error

5

Hello @davrans,

You specified it as B2/12 and it repeats the formula for every row. it's a static value in this template and is not changed.

You can add a formula the same manner as it's done for the Quarter salary

image
image695×190 5.53 KB

image

It won't work with the static value and the {[equals}} tag that doesn't match any value in the JSON.

Best regards,
Petr
Plumsail team

6

In my real case I use data from json and also reference to an another column in the same raw

In the example I tried to make it as simple as possible. Do you mean if I use {{equals}} then formula always will be static (without incrementation)?

7

Hello @davrans,

Yes, you need to use a formula the same manner as for the the Quarter salary.

Best regards,
Petr
Plumsail team