When a cell in a Table row changes, I need to pass in the row number so my custom function can make multiple amendments to that row.
I have this formula set in one of the cells so when [@[REGION_ASSIGNED]] changes, the row number is passed in (for that single row).
Everything works fine EXCEPT, ROW() seems to cause EVERY row in the table to call the function (instead of the one row that is expected).
Any ideas?
Cheers
I have this formula set in one of the cells so when [@[REGION_ASSIGNED]] changes, the row number is passed in (for that single row).
Code:
=ChangeFlag("DATA",ROW(),[@[REGION_FLAG_IMAGE]],[@[REGION_ASSIGNED]])
Everything works fine EXCEPT, ROW() seems to cause EVERY row in the table to call the function (instead of the one row that is expected).
Any ideas?
Cheers
Last edited: