Formula for cell value

In attached image i'm trying to get the highlighted GREEN of second column cell value into highlighted BLUE of first column cell.


What formula needs to write to achieve this ?





Best Answer

  • Joris
    Answer ✓

    Hi Satish, 



    This could be something in the direction of:

    IF ITEM(ListName) = ListName.Gross Revenue THEN Gross Revenue[SELECT: ListName.Total Contract] ELSE XYZ

    where "ListName" represents the name of the list you are using for the contract elements and "XYZ" represents the formula that is currently already in place in the "Value" line item.