Need a help to find a logic for valid if condition

[Harsha0071]

Hi all,

I had a table in which I have a component which is required and main which is optional and project_id, now project id should be created when 

1)if only component which is enum selected then all main enum list containing value should be created and visible in the table.

2)if I select component and one value in main then that main value with the same component in the next iteration doesn't want to create 

3) similarly, like in the 2nd scenario if I create multiple bu's let's say 2 or 3 in main which enum list that records should be created and then single main or multiple main on 2nd iteration of that same main values given doesn't create 

4)if I give multiple main's values in 2 iterations then common bu's value should not be in the 2nd iteration 

5) if all component team main's are created then again it should not be able to create until there is a column called status which is closed  and also there is status column when it is open same combination should not work.

I want valid if condition unless these conditions pass I be able to create or generate id 

• In the appsheet I need logic to implement this can you help me with this ?

[Steve]

Please refer to my response in your other topic..

[Harsha0071]

Hi Steve,

Thank you for your suggestion. I tried implementing it, but unfortunately, it didn’t work as expected. Could you please take another look into this or provide further guidance? Your assistance would be greatly appreciated.