Hi guys, i need help in creating list view for months (Jan, Feb.. Dec) in sharepoint

Anonymous
2022-04-19T17:02:08.387+00:00

Hi guys, i need help in creating list view for months (Jan, Feb.. Dec) in sharepoint

Let say, i have columns 1 Client, columns 2 Partner, column 3 Leader, column 4 Year and the rest columns (Jan, Feb, Mar...Dec)

(case 1) If i want to add target for Client A for 1 month for Mar, i should have details options in list to enter (columns 1 Client, columns 2 Partner, column 3 Leader, column 4 Year and target amount for Mar and i rest months will be empty), then i can hit on save.

Again, (case 2) If i want to add target for Client B for 12 months for Jan-Dec, i should have details options in list to enter (columns 1 Client, columns 2 Partner, column 3 Leader, column 4 Year and target amount for Jan-Dec ), then i can hit on save.

Again, (case 3) If i want to add new target for Client C for 6 months from Sep(this year)-Feb (Next year), then i can add the same way, as i was doing it in case 1 and 2.

Again, (case 4) If i want to add the new target for client D for 15 months from Jan(current month) -Mar (next year)

I don't want my target value should overlap the existing months value.

Thanks

SharePoint Server
SharePoint Server
A family of Microsoft on-premises document management and storage systems.
2,221 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,625 questions
SharePoint Development
SharePoint Development
SharePoint: A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.Development: The process of researching, productizing, and refining new or existing technologies.
2,668 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. CaseyYang-MSFT 10,321 Reputation points
    2022-04-26T09:27:42.23+00:00

    Hi @Anonymous ,

    You could create a multiple choice column as a workaround.

    1.Add column > More > Choice (menu to choose from) > Type each choice on a separate line > select Checkboxes (allow multiple selections)

    196478-1.jpg

    2.My test result:

    196459-2.jpg

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments