Formula to pull data from one member to another of the same list

Shally
Not applicable

Formula to pull data from one member to another of the same list

Hi

What formula does one use to pull data from Member1 to Member2 of L1

L1

  |-- M1  - 10,000

  |-- M2 

 

or

from Actual to Budget ?

 

3 REPLIES 3
Sorna Raja Prabhu
Community Boss

Re: Formula to pull data from one member to another of the same list

Hi @Shally, Use LOOKUP function.

 

Create a System Module for mapping the list members in same list.

 

 

Capture21.JPG

 

 

 

Capture22.JPG

 

 

Thanks,

 

Sorna Raja Prabhu
Sorna Raja Prabhu
Community Boss

Re: Formula to pull data from one member to another of the same list

@Shally  - For versions you can use PREVIOUSVERSION or NEXTVERSION function

 

 

 

Sorna Raja Prabhu
Kanishq17
Community Boss

Re: Formula to pull data from one member to another of the same list

hi @Shally 

you can use lookup , create a table for mapping each element with value of list you need from and then use that mapping as lookup in target module

 

here create a module with the l1 list and a line item with same l1 list as its format, then map m2 to m1