There should be a function to convert Date to Text -- call it TEXTDATE(x)
That would be great if there was a TEXTDATE(x) function.
There is a way around it that includes concatenating text fields based on the DAY(), MONTH(), and YEAR() of a particular date.
I will demonstrate by using the day function, only to show an array of dates with multiple output options:
First, I create line items for the Text output for the Day, Month, and Year, I have separated them for display purposes but these line items can be nested into one if memory is a concern.
Next, I created multiple outputs in case there are different countries or business criteria across the company.
Below if the grid view for the outputs of the different date formats:
Thank you for this solution. This is helpful as there is no other option but creates unnecessary calculations and increases clutter.Vice versa the formula should work in the opposite way too.
I am working on a use case where I need to display the top 5 lines of a module as individual lines, while grouping all remaining lines under an "Others" category. The module is dimensioned by multiple composite hierarchy lists, along with Time and Version. To achieve this, I need to use the RANK function with the Ranking…
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…
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…
