Hi there -
am new to anaplan have only used excel extensively. I need to add a conditional colum (col 2)n based on another column (col1) which is a list type. That is if col1 contains "x1" or "x2" then 1 else 0.
Thank you
Perhaps try using a selector module to define which list items you want to flag as a 1 and then in a separate module where the data lives do a LOOKUP to those list items you have flagged. This allows you to dynamically control which line items should be selected rather than hard coding the formula. Rough examples below to help illustrate.
Hi im trying to update the success criteria actual column = if status is "Achieved" or "On Track" then 1 else 0?
Hello All, Is possible to Data label colours based on Legend? By default the Axis in ANPALAN steps up by 2.5K, how to manually adjust? Data labels for all legends is not displayed, possibly due to size, how to move the labels TIA
Hi, I was hoping to get some help with this situation, where I am trying to take a list to list mapping on the left and get an output similar to the right, but the main idea is i want to be able to make the selected item (format: list), the dimension of a target module and reverse map the original source list as a list…
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…
