How to Update a Choice Pill Column in SharePoint Based on a Date Column?

Dear @Cherokee Wright,

Good day!

We regret to inform you that SharePoint does not currently support dynamic updates to a choice column based on the value of another column, such as a date field, without the use of Power Automate. This is a technical limitation of the platform, and we understand that it may impact your workflow or expectations.

Kindly try to use a separate status column (e.g., "Final Status") that can be manually updated.

Or you can use Power Automate to set up your requirement. Kindly consider this article as a reference: How to implement a calculated column using 'Created' column and 'Status Update' column | Microsoft Community Hub

Once again, we sincerely apologize for any inconvenience this may cause.

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.

Dear @Cherokee Wright,

We hope you're doing well. We just wanted to follow up and see if the solution we provided helped resolve the issue you were facing.

We haven’t heard back from you yet, and we want to make sure everything is working smoothly on your end. If you’re still experiencing any difficulties or have any questions, please don’t hesitate to reach out—we’re here to help.

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.

Dear @Cherokee Wright,

We hope this message finds you well.

This is our second attempt to follow up and ensure that your issue has been resolved. Our goal is to make your experience as smooth and seamless as possible. If the issue persists or if you encounter any new challenges, we kindly ask that you share more details about the steps you are currently taking. We are always happy to assist whenever needed.

While we await your response, we will continue monitoring other customer inquiries on the forum to provide support where needed. Should you have any further questions or updates, please feel free to tag @Huy-K in your reply so we can respond promptly and thoroughly.

We look forward to hearing from you soon.

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.

Hi,
Unfortunately, I require that flexibility.
I will have to look for other solutions.

Unfortunately, the suggested actions aren't applicable in this case, as a calculated column cannot be edited once a project is marked as "Completed" or "Withdrawn." These statuses may not necessarily align with the Due Date, which limits the flexibility of the proposed solution.

Dear @Cherokee Wright,
Could you kindly share a screenshot of your comment for reference? Based on our testing, the code functions correctly; however, when the Date column is modified, the Pill column also updates accordingly.

Could you please clarify what level of flexibility you are seeking in this scenario?