Forum Discussion
Automatically hide columns without data in a large document
Hi, I’m actually wondering if this is possible to achieve, and how advanced it is if so? I work in a large RACI matrix, and it is becoming quite clear that there are quite a few roles and activi...
I suspect you are hoping for a filter button that magically conceals the columns that are not relevant to a specific task. This approach uses 365 formulas and is somewhat different.
The formula is
= LET(
selection, XLOOKUP(selectedActivity, Activity, assignments),
TRANSPOSE(FILTER(VSTACK(roles, selection), selection<>"", "None"))
)and it returns a column of data for the selected activity