Setting item descriptors like cells ?

3.46K viewsFormulas and Functions


Is there a way to use item descriptors like cells, set (not only read with @) item descriptors by formulas and then sort the items using the descriptors ?

I think it would be very usefull. Often the objects (eg companies) have elements that do not change (eg company name) and elements that do change (eg quarter sales, costs, results). If you add a category “quarter” to such object, it ends up in duplicating the company name in every quarter. And so on for all the dimentions you add. The result is poor readability (half the screen is filled with the company name) and unnecessary computing resource consumption.

On the contrary, manipulating the descriptors through formulas like for the cells would allow to mix in the same table “multi dimension” data (here quarter data) with “one dimension” data (here the comapny name).

I did not find a way to do it. Does it make any sense ?


Descriptors in a “data” matrix can be updated from a column in a “directory” matrix via datalink, but it should not work here because the category holding the descriptors in the data matrix are normally linked to a category in the directory matrix (the category “employee” in sroever’s example): datalink does not allow this.
Another workaround is using a canvas where the directory matrix is placed at the left of the data matrix and they are snapped horizontally along the relavant category (which is hidden in the rightmost matrix). Needs some manual tweaking, but it’s better than a column in the data matrix repeating the descriptor in each dimension of the data. And you can also apply conditional formats, sorts, filters, all things that aren’t available in descriptors (or items as well).
For future releases, I agree that it would be desirable to have more dynamic descriptors.

You are viewing 1 out of 5 answers, click here to view all answers.