Flag list member based on whether it's referenced on a property of other list members
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 ?
FIRSTNONBLANK must work. If isblank(Promo copied from[FIRSTNONBLANK:Promo copied from]) then "not used" else name(Promo copied from[FIRSTNONBLANK:Promo copied from])0
Super! Thanks a lot @KirillKuznetsov , much appreciated!0