The Special Dates Smart Column is a powerful monday.com app designed to automate the process of identifying and labeling key dates, such as public holidays and weekends, within your board. By triggering this app, you can automatically check an entered date and update a status column to reflect whether that date is a special day, saving you time and ensuring accuracy in your project planning.

Use cases:

• Project Scheduling: Automatically flag task deadlines that fall on a weekend or public holiday, allowing you to proactively adjust timelines and avoid delays.
• Resource Management: Track employee availability by instantly identifying non-working days for staff members who are assigned tasks based on dates in the column.
• Data Validation: Ensure accuracy in your dataset by using the status column output to filter out or highlight dates that require special attention, such as non-business days.

Step-by-Step Setup Instructions

Follow these steps to install and configure the Special Dates Smart Column on your monday.com board:

1. Install the App

1. Locate the desired Date Column on your board. This is the only column type where the app can be installed.
2. Click the three dots (•••) next to the Date Column title.
3. From the drop-down menu, select Column Extension.
4. In the subsequent menu, click on Special Dates.

2. Configure the Settings

Once the settings box appears, you will set up the trigger and the output column:

1. Set up the Trigger and Columns:

• Select the Status Column where you want the holiday results to be displayed (e.g., a column you’ve named “Status” or “Date Type”).
• Select a country from the dropdown.

2. Choose an Activation Method:

• Select a method to activate the trigger. This determines when the app checks the date. Your options are:
  • Item created
  • Item moved
  • Column changed
  • Status changed

3. Example Setup and Activation

Here is an example of a common setup using the “Column changed” trigger:

1. Choose Column changed as the primary trigger method.
2. Select the Date Column change to specify that the app should activate whenever a value is entered or changed in the Date Column.
3. Click Save.
4. Finally, refresh the page for the app to take effect.

The app is now active. Whenever you enter or change a value in the date column, the trigger will automatically activate, identify the nature of the special date (e.g., “Public Holiday” or “Weekend”), and label the designated status column accordingly.