How to change the lookup options based on the value in a particular cell?

[Mufeed_Areekkan]

I have a table with three columns. ‘Task’, ‘Task Type’, ‘Status’. I want to have a different dropdown list shown in the ‘Status’ column based on the ‘Task Type’. Is there any way to do this?

[Quentin_Morel]

Hi @Mufeed_Areekkan

Yes of course, check this little screenshot

• Create a table with your task type and whatever status you want with comma separation for example

• Convert your text list as an actual list

• In your main status, enter your option using a filter on task type table, according to the current task type.

• And voila :

Enjoy,

Q.

[Mufeed_Areekkan]

Thanks! This is just what I was looking for.

[Quentin_Morel]

Perfect then, enjoy this feature and do not hesitate !