when modify one column how to cascade update other related columns

[zhugw]

There are col1, col2, col3, col4, col5, col6,col7,col8 and

col4 = co1*col2*col3/500
col5 = col4/1000
col6 = col7/col4

Want once modify col1 or col2 or col3, other cols could also be modified. How to implement this purpose ?

[naterush]

Currently, the best way to accomplish this is to just reopen the cell editors for the columns you want to update and resubmit the formulas. Does this work for your use case @zhugw ?

[zhugw]

It works, but I want it could be updated automatically and just current row, not entire dataframe