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

Taran_Bhagat
Participant IV

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

0 6 373
6 REPLIES 6

Are you using a formula such as

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

Taran_Bhagat
Participant IV

@Bellave_Jayaram No. I have used Valid_if

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

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

Taran_Bhagat
Participant IV

@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
Participant IV

@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
Participant IV

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

Top Labels in this Space