Display Two Column's Value in Coda

I have a sample table values below.

Jurisdiction Doc Type Adopts Publication Year

Alabama Amendments IBC 2021
Alabama Amendments IBC 2019
Alaska Integrated IFC 2013

My formula below only returns 1 column value

Codes.Filter(Jurisdiction=''Alabama AND [Doc Type]=“Amendments”).[Adopts Publication]

Output:

IBC, IBC

I want it to output,

[IBC, 2021],
[IBC, 2019]

Hello @Alyssa_Gono

The formula you have renders what you ask it to (only the Adopt Publication info), if you want to get both information you should write something like this if it’s OK for you :

Please let me know if it’s OK or not ?

Quentin

2 Likes

Thanks, such a great help.

1 Like

Happy to help :slight_smile:
See you in another post !

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.