Is it possible to filter columns just like rows?

Can I programmatically choose which columns in a table will be shown?

For example:

Table 1 has:
Col1, Col2, Col3, Col4, Col5
row1
row2

In Table 2 I want to only see:
Col1, Col3
row1
row2

I want to do this with a multi-select control if possible. In the multi-select control I will pick: Col1, Col3.

Is this possible?

Short answer: No :smiley:

But if you tell us a bit more about your use-case maybe we can recommend a work around.

1 Like

It was just for a more focused view of a bigger table. Thanks for the quick answer.

Have you considered creating views?

Yes, which columns will be visible can be configured on the web. But this solution would be useful in both web and mobile.

Not too helpful, but this sounds related to this discussion, I just want to link these together :slight_smile:

1 Like

Not exactly the capability described here but that is a feature I would love to have.

I found out this short time ago:

Above link summarizes well coda’s system.

The use case I need this is that I have a table with different currencies (USD, EUR, XAU …) as columns. I track the currencies with dates in rows. I currently pull the desired currency with Switch(). But being able to flawlessly index columns as we do with rows would be amazing.

Just gave an upvote. :slight_smile:

You should have started there! Putting variables in columns is another bad habit from excel, that we need to get rid of if we want to make progress in Coda. Take a look at this sample doc, no need to filter columns anymore! If you still want to visualize the data in columns you can do so with grouping like I demonstrated, but the source data should be in rows.

For what use-case exactly?

Sorry @Rickard_Abraham , this still isn’t a genuine case for column formulas!

3 Likes