Is it possible to colour input line items for ease of inputting. Also this colour should be present even before any data is inputted.
Hi, you can achieve this by using conditional formatting.
Hi @RajalakshmiV
You need to create two line items. CF1 and CF2, put 1 in CF1 and 2 in CF2 as formula.
Use these line items to conditional format the required line items with different colors.
-Shubham
This works. Wanted to confirm on the formula for CF if there is any alternative apart from writing a fixed number :)
Thank you!!
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…
