I have 60 database fields
Shares1, Shares2, Shares3, Shares4... all the way up to Shares60.
Each "Shares#" field is tied to a vesting date.
Instead of inserting 60 rows of details (one for each Shares# field), I'm hoping I can create a single formula field that will automatically insert rows if the share value is greater than 0 for the next Shares field.
For example. If Person #1 has Shares1 = 100, Shares2 = 50 and Shares3 = 0 then I want it to look like this.
Name Shares
Person 1 100
Person 1 50
I will need to do that same thing for the vest date.
Does this make sense?