I have a table called [HMB-002-102 Training Matrix], and I’m using this formula to get the row I want: [HMB-002-102 Training Matrix].Filter([Name modified].ToDate() = Today())
This correctly returns the row for today.
Now, I want to add onto this formula so that it returns the names of all columns in that row where the value is “X” (or not blank).
For example, if today’s row looks like this:
Name modified
SOP 101
SOP 102
SOP 103
2025-10-07
X
X
…I want the formula to output: [“SOP 101”, “SOP 103”]
Ideally, I’d like a formula-only solution, without using automations.
I tried variations using Columns(), FormulaMap(), and WithName(), but Coda doesn’t seem to allow dynamically referencing r.[CurrentValue] inside a loop.
Has anyone found a reliable pattern for this, basically getting a row’s column names dynamically when the column values match a condition (like “X”)?
Any guidance or example formulas would be super appreciated!
@Elaina_Kreher This isn’t possible in Coda now without you specifying statically which column the formula to check, and that is to retrieve the row value if you know the columns value. Retrieving column names after checking against a condition is not possible.
I would recommend you to change your data model that the “columns” are in fact rows in another table and via relation you can check against the specific condition and retrieve the specific rows from the second table.
I would advise you to drop in here a dummy doc with anonimized data with what you have now and the community can chip in easier.