Formula that checks all conditions

OK then,

You could work with somehting like this.

image

That works but the formula is not very beautiful

CPT2212081524-739x374

May I suggest, rather than using different columnl like that, to have an row-based approach ?

Instead of having multiple columns (that is difficult to work with), consider creating a table with a “project” column, that will be displayed in several row, each row for an OS, like this. You can make the OS choice as a lookup to another table, so that you can easily add or remove new OS

Bust most important, make the project column as a lookup to a project table, and use this formula directly in the project table to get information of which OS is ticked for each project

This is clearly better, and more in the spirit of coda logic

CPT2212081530-847x796

And you can use group by display option

please find the embed doc with two options, and let me know what you think.
Quentin

1 Like