I have boolean type 'Current Year Month?' and 'Last Year Month?' line items.
To how populate them easiest way without huge amount "support rows".
Attached pic. (in the pic the green ones. Now they are manually fed)
@Miia
in the formula for last year: yearvalue(Last Year?) line item. same for the current year put the formula as Yearvalue(current year?) .
If still facing any issues let me know.
If you are updating current period of model calendar, try
YEAR(CURRENTPERIODSTART()) = YEAR(ITEM(Time)).
Thanks! - on my case YEARVALUE() worked - sometimes you just get stuck on simple stuff 🙃
Hello , you can use the YEARVALUE() function to replicate year values across months
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…
Does anyone also get this error when opening the Forms in Anaplan FCR? I am downloading Investment Registry from the app but I cannot open it in Anaplan XL. How did you fix this issue?
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…
