Filter available selections based on entry in another column?

1

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.

2

You can use the following formula:

Lookup(Projects,Client,thisRow.Client)

Sample doc:

3

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

1 Like