You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Dynamically update formula

If I am using a formula in a column referencing Row 1. For example in Column B i am using [1]/100.

Now row 1 is enabled for zoom, so i want when it is zoomed the corresponding values from the rows are picked for the formula, but it picks the value at the top parent level. How do i achieve the same?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!