When changing format options for a row/column on a grid card, instead of selecting the item from a dropdown list, a nice QoL feature would be to auto-select the item directly on the grid, clicking it.
Is that a suggestion or a question? I believe it won't be easier to auto-fill the dropdown based on a click on a list item, as the dropdown will be dimensioned by the user. While having such a feature could be beneficial, it might not provide significant advantages for developers/ end users. If selection is needed, synchronization or hierarchy filters are already available to view the data by clicking on the list item. Implementing a similar option for dropdowns would be structurally challenging and might not yield substantial gains.
i have a time settings module dimensioned by time and version. I need to check for months and years in one line item. Is there a formula i can use that will only allow me to tick for months and year and exclude Quarter?
I have created a time settings filter with native version as a dimension. I am suppose to tick true for all the actual months. In Actual version the actual months will be until Aug 20 (because my current period in model calender is Aug 20). A switchover is applied for budget and forecast which is at Feb 20 and Sep 20.…
I couldn't find any formula to do this, but I want a way to put on the page/grid the connection details. This is so I know what connection I'm in rather than going into Connections details to see it. Is there an XL3 formula to return this value?