Forum Discussion
SharePoint List Column Conditions
Hi David Noble! I would suggest additionally creating 1 Master list. Column 1 is a source for your hardware entries, column 2 is another source for your software to be defined.
Then you go back to your Detailed list and create 2 lookup columns, one for HW and the second for SW. HW is a lookup for column 1 in your Master list. SW is a lookup for column 2 in your master list. Greets, Eva.
Hi Eva Vogel thank you for you reply.
I'm thinking on the lines of this.
If I select either Hardware or Software in Column A. Then Column B will show either Hardware items (PC, Server) or Software items (Word, Excel) depending on what was selected in Column A.
Hi David Noble ! You can make that with only one lookup column and an additional calculated column which refers on chosen lookup items with "IF" Function. If someone chooses an item which is Excel or Word or PowerPoint from lookup list, then its "Software" as text result in your active list, else its "Hardware" (text result). Could be that way.
Greets, Eva.
Hi Eva Vogel could you give me an example IF formula?
