nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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!

Accepted answers

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

All comments

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])

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

Alessio_Pagliano

Super! Thanks a lot @KirillKuznetsov , much appreciated!

Quick Links

Can you help?

Unanswered questions

Anaplan workspace account
I’m having trouble recovering access to my Anaplan workspace account. Could you please help me?
Integration Process Execution Access - Which Access Takes Precedence?
We have an Integration Process in Anaplan CloudWorks created by User X - No WSA (originally Full Access with top-level Selective Access, now changed to Planner Read Only with Selective Access unchanged) and scheduled by User Y - with WSA , who also created the Integration Flow. Internal (Full Access) is enabled within the…
Anaplan ⇄ Google Sheets pivot tool — feedback welcome
We've been building a tool called aplan4sheets and we'd genuinely like input from this community — both on what we've built so far and on what we should prioritize next. The problem we set out to solve: Anaplan's Excel add-in is Windows-centric, and there's no real native way to pivot Anaplan data in Google Sheets. We…