Filter available selections based on entry in another column?

This is probably something but I’m not coming right in the docs and the YouTube and my Google-fu has let me down.

I have a tasks, clients and projects tables.

On the tasks table I want to select a client and then a project but I want the available projects to be limited by the selected client.

The projects table has a clients comlumn that links the 2.

You can use the following formula:


Sample doc:

Thanks very much. That was a point in the right direction. I’ve got it working now.

1 Like