SharePoint Document Issues

How to Fix Missing Date and Red Question Mark on SharePoint Files

Amos Gikunda Oct 10, 2026 868 views

Question details

Users need to remove the missing date prompt and red question mark indicator next to files in a SharePoint document library.

How to Fix Missing Date and Red Question Mark on SharePoint Files

Product: SharePoint
Device & OS: not provided
Scenario: Viewing, organizing, or uploading files within a SharePoint document library.
Observed behavior: Files display a red question-mark indicator and a missing date warning because the document library contains a required metadata column that has not been populated.

Before you start

Ensure you have Site Owner or Administrator permissions for the SharePoint document library, as you will need access to the Library Settings to modify column requirements.

Solution 1Recommended

Make the Metadata Column Optional in Library Settings

Change the required metadata column to optional so files no longer prompt for missing dates.

This issue occurs when a SharePoint document library is configured to require specific information (like a date) for every file. Modifying the column settings will remove the red question mark indicator for all users.

Open Library Settings

Navigate to your SharePoint document library, click the gear icon in the top right corner, and select 'Library settings' from the dropdown menu.

Disable Content Types (Optional)

Select 'Advanced settings'. If your library does not require them, disable 'Content Types', then return to the main settings page.

Modify Column Requirements

Under the 'Columns' section, click on the specific column that is asking for the missing date.

Turn off Requirement

Locate the 'Require that this column contains information' option, set it to 'No', and click 'OK' to save your changes.

Make the Metadata Column Optional in Library Settings

Permission Required: Only users with Site Owner, Administrator, or appropriate Design permissions can access and modify these Library settings.

Free Microsoft Office alternative

Create and Edit SharePoint Documents Seamlessly with WPS Office

While SharePoint helps you store and manage files online, you need a reliable suite to create them. WPS Office is a free, lightweight, and highly compatible alternative to Microsoft Office that makes editing documents, spreadsheets, and presentations a breeze before uploading them to SharePoint.

1. Download the Software: Download and install the free WPS Office suite from the official website.
2. Edit Your Documents: Open your downloaded SharePoint files in WPS Office and use the familiar tools to make edits.
3. Save and Upload: Save your work in standard Microsoft Office formats and re-upload the finalized documents to your SharePoint library.

Fully compatible with Microsoft Office formats (.docx, .xlsx, .pptx) for seamless SharePoint integration.Free and lightweight, consuming minimal computer resources.Familiar user interface with zero learning curve for immediate productivity.All-in-one software that combines Writer, Spreadsheet, Presentation, and PDF tools.

microsoft office alternative - wps office

Frequently Asked Questions

What does the red question mark mean in SharePoint?

A red question mark next to a file in SharePoint indicates that the file is missing required metadata, such as a specific date or category. This information must be filled out before the file is considered fully checked in.

How do I fill in the missing date metadata for a single file?

Select the file in the SharePoint library, click the 'Details' pane (the 'i' icon) in the upper right corner, and fill out the required date field in the properties section.

Why can't other users see my uploaded SharePoint files?

If a file is missing required metadata (like a missing date), it may remain checked out to you. Other users will not be able to see or edit the file until the required information is provided and the file is checked in.

Document & File Issues