Sharepoint Lists - Dually format Column with date type and choice type

Question

I am creating a MS List document that has over 200 rows, all of which are individual projects, with 32 header types. The first 5 columns are text and person column types and the remainder of the columns are date and time. My question will pertain to the date and time type columns.

My date and time columns are used to project item completion dates for individual projects. My team needs the ability to have individual date and time cells color coded by user discretion to indicate their level of confidence in date completion.

I would also like to set up the individual cells to have the option to convert from date and time type to choice type, so when an item is complete we can mark the cell as "complete" and stop tracking a date. Ultimately, when a project has all of its dates converted to "complete" the project will be removed from the list.

Is this possible?

I found a youtube video describing how to inlineEditField types which gave me this idea.

Thank you,

Rob

Answer 1

Hi @Anonymous ,

Are you using SharePoint Online?

For the first question, you can use the column formatting. As you don't give a specific question, so I just give you some articles for your reference:

https://learn.microsoft.com/en-us/sharepoint/dev/declarative-customization/column-formatting#apply-formatting-based-on-date-ranges

https://learn.microsoft.com/en-us/sharepoint/dev/declarative-customization/formatting-advanced#inline-editing

https://learn.microsoft.com/en-us/sharepoint/dev/declarative-customization/formatting-syntax-reference

For the second question, the type of column can not be changed.

You can differentiate the degree of task completion by creating different views.

Or delete it directly when it is completed.

---

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.