Forum Discussion
joao_PT
Jan 28, 2025Copper Contributor
2 microsoft lists ?
I have a excel file with the following info:
sheet 1: List of requests
sheet 2: List of proposals
The columns in each sheet are completely different.
I'd like to use sharepoint (micrososft lists) instead of using excel. Do I need to use 2 different sharepoint files ? it is possible to "aggregate" them
in excel is easier to change between sheet, but in the sharepoint do i really need to change the page ?
- ArefHalmstrandSteel Contributor
Hello,
Yes this is possible. :)
You can decide if you want to have two different SharePoint Lists or using the same.
If you would like to use the same list, you would need to have a two different content types applied to it.
Content type 1: Requests
Content type 2: Proposals
Within each content type, you will apply the fields that you require.
When creating a new item within the list, you will always get the option to create A (a request) or B (a proposal).
Finally, you can create two different views within the list, that will show either the proposals or requests.
If you would like, I can help you out through a MS Teams call. :)
Yours sincerely,
Aref HalmstrandPlease mark as solved if this was helpful. 😊