I currently have a SharePoint site set up that contains a status field. Based on the status (opened or closed), the items will be grouped by status.

I want to remove the status field and have a closed date field. Once the closed date field is populated, the closed items will be grouped into a closed group. If the item is not populate, it will remain in an open.



List > List Settings > Create View

Call your view whatever your want - perhaps "open items"

Under the filter heading, choose your date heading, select 'is equal to' and leave the field blank.

| improve this answer | |

What it sounds like to me is that when your closed date field is populated, you want the status to automatically change to 'Closed', and then your items would automatically be grouped into the correct Open/Closed group based upon the status.

I would build a quick workflow in SPD for this to run on an item change. If you haven't already, set the default value of Status to 'Open'. Then, using the workflow, change the Status to 'Closed' when the 'Closed Date' field is not blank.

In your view, group by the 'Status' field, and make sure your Status field is hidden (unchecked) within the view.

This way, you'll have an 'Open' and 'Closed' group, and when the closed date is populated, the item will automatically move from the 'Open' to 'Closed' group.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.