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

Alessio_Pagliano

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 ? 

Thanks!

 

KirillKuznetsov

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

 

KirillKuznetsov

Hi @Alessio_Pagliano 

FIRSTNONBLANK must work. If isblank(Promo copied from[FIRSTNONBLANK:Promo copied from]) then "not used" else name(Promo copied from[FIRSTNONBLANK:Promo copied from])

 

Alessio_Pagliano

Super! Thanks a lot @KirillKuznetsov , much appreciated!