You are viewing limited content. For full access, please sign in.

Question

Forms

Updated January 10, 2024

asked on January 10, 2024

In my table, choosing type will automatically fill out the pay rate.

Im using the formula "=Table.Type" in the Pay Rate field. That works.

However, when I add a second row and choose a different type, it changes the pay rate in both rows.

How can I fix it so the pay rate is independent to both rows?

0 0

Answer

SELECTED ANSWER

replied on January 10, 2024

When you're working with collections or tables, you need to add an INDEX that specifies the ROW.

So, instead of =Table.Type, this would look like: = INDEX(Table.Type,ROW()) - this tells it to use the value from the current row.

1 0

replied on January 10, 2024

Awesome, thanks you so much!

0 0