I want to do a quite simple thing but I can’t make it happen.
I have Table1 with different unit costs and that is connected to Table2.
In Table2 I want simply when I select “Individual project” in the Name column, Column 2 automatically switch to “Individual” option. If it is not Individual project then “Group”.
I try to do an If Formula as a filter in Table2 Column2 but it doesn’t work.
Do you have any tip what am I missing?
Here is the doc: https://coda.io/d/_dEQbdZTtPZQ/Select-list-auto-option_suqOX
Thanks a lot!