Display Two Column's Value in Coda

Alyssa_Gono · October 20, 2022, 2:38pm

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]

Quentin_Morel · October 20, 2022, 4:37pm

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

Alyssa_Gono · October 20, 2022, 4:48pm

Thanks, such a great help.

Quentin_Morel · October 20, 2022, 5:08pm

Happy to help
See you in another post !

system · October 23, 2022, 5:09pm

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