I am using valid_if to see a list of tasks un...

[Taran_Bhagat]

I am using valid_if to see a list of tasks under a project as dependent drop-down. But the app shows

all

the tasks common to different projects. Where am I going wrong? App name Buildsmart1-213475.Please access and advice

[Bellave_Jayaram]

Are you using a formula such as

SELECT (Tasks[Task], [_THISROW].[Project]=[Project]) ?

[Taran_Bhagat]

@Bellave_Jayaram No. I have used Valid_if

=task[Task Description] in report table to look for tasks belonging to a project table

[Bellave_Jayaram]

Use a SELECT formula like the one I gave and replace the table and column name as needed.

[Taran_Bhagat]

@Bellave_Jayaram Cant do it correctly.Not good at writing command code.Really don’t know exactly where to put and call for what? Also when I did it the older projects are not available in the drop-down. Instead every time a new is required to be added

[Taran_Bhagat]

@Bellave_Jayaram Please explain to me the meaning of SELECT (Tasks[Task], [_THISROW].[Project]=[Project])

in the context of my app Buildsmart1-213475

[Taran_Bhagat]

@Taran_Bhagat Thanks. Things are working well as per your guidance