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

(Taran Bhagat) #1

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) #2

Are you using a formula such as

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

(Taran Bhagat) #3

@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) #4

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

(Taran Bhagat) #5

@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) #6

@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) #7

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