Forum Discussion
Change choice column based on Date
Hello, I am looking to see if the value of a choice column in SharePoint can be set based on the Date of another column, or by the color of another column. I have an "End Date" column that i have ...
SteveKnutson Thanks for your response.
I ended up changing the "Status" column from a choice field to a calculated column and used the following formula to have it auto set the field.
=IF([End Date]>TODAY()+60,"Active",IF([End Date]>TODAY()+30,"Expiring Soon","Expired"))This also allows the status column to dynamically update when the different date requirements are met.
SteveKnutson Thanks for your response.
I ended up changing the "Status" column from a choice field to a calculated column and used the following formula to have it auto set the field.
=IF([End Date]>TODAY()+60,"Active",IF([End Date]>TODAY()+30,"Expiring Soon","Expired"))This also allows the status column to dynamically update when the different date requirements are met.
That is a great approach. Thanks for sharing the solution. Well done!
