Creating 3 fields that rely on each other

Hi folks,

I'm trying to create the fields attached in Designer. Changes in Shares is an existing field, and Treasury Shares is just an IF ID=1 then 1,234,567 else Changes in Shares + Row-1 Treasury Shares. The rest of the fields are dependent on another field already existing.

Can someone help me figure out what order I need to create the additional fields in, or suggest a tool that will allow for this sort of interdependency?

Thanks!

Example.xlsx

Help

Accepted answers

All comments

Amarendra

Sounds like you can use the Multi-row formula tool. Did you try using that?

MP36

@Amarendra I've tried using multi-row, but I can't seem to get the formulas into any rational sequential order. I think I would have to reference columns that don't exist yet.

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703