Flag list member based on whether it's referenced on a property of other list members

Alessio_Pagliano
Alessio_Pagliano
in Modeling

Hi, 

I'm sure I'm having a blond moment. What's the easiest way to achieve the equivalent of this Excel formula/situation (Column F), in Anaplan ? 

Alessio_Pagliano_0-1660836774700.png

Thanks!

 

Tagged:

Best Answer

  • KirillKuznetsov
    KirillKuznetsov
    Answer ✓

    Better to split formula in two line items:

    "Promo mentioned" = NAME(Promo copied from[FIRSTNONBLANK:Promo copied from])

    "Value" = IF ISBLANK(Promo mentioned) then "not used" else Promo mentioned

     

Answers

Categories