developer not going into any project

[pasupathi]

i have 2 columns 

ProjectStatus                   DeveloperName            

DEV                                      A

Developer allocated             B

FSD                                       C

Hold                                     D

Hypercare                             E

Live                                       F

UAT                                      G

question: if any developer name is not under any projectstatus show the developer name

[Anonymous]

Hi @pasupathi ,

In the sample data you provided above, each Developer has a Project Status.

How can you tell if the developer is not in any project state, the project state column is blank like below?

If so you could just add a filter like below:

If I misunderstood your requirement, please show more details.

Best Regards,

Jay

[pasupathi]

i have only single table in that table i have 19 columns out of that i have two columns shown above 

ex: i have 11 developers out of 11 developers 9 developers have a projects but 2 developers doesnt have any projects show the 2 developers name  

[danextian]

Hi @pasupathi ,

Please share a sample data and your logic - How would you know if a developer doesn't  have any project? Where is in your data can that be found? What will indicate the there are no projects?

[pasupathi]

 have only single table in that table i have 19 columns out of that i have two columns shown above 

ex: i have 11 developers out of 11 developers 9 developers have a projects but 2 developers doesnt have any projects show the 2 developers name 

[dhruvinushah]

Hi @pasupathi ,
Give more details on your question. is this an issue where the developer name is present in the table but not associated to any project status? Are the fields in seperate tables and you have a relationship between them?
Please give more information.