Set Up Columns Notification For Free

Create an Alert Right click on the library, folder, document set or file you want to monitor and select the Alert Me option. You can then set the conditions for the alert. On libraries, folders and document sets. Or on files.

For Excel to communicate with an email server, you need to add a reference to EASendMailObj ActiveX Object 1.0 Type Library. This reference is added by navigating to Tools -> References in the VBA editor and selecting ?EASendMailObj ActiveX Object 1.0 Type Library? from the list of available references.

Go to the actions panel, select the email icon, then add your formula (example: B2<10%), and then add an email subject, the person who will get the email and click on save. Once that's done, your Factivate spreadsheet will automatically generate an email once B2 changes below 10%.

Choose the cells that contain the due date for which you want to be reminded. On the Ribbon, click the Data tab, and then click Data Tools. In the Data Tools group, click Data Validation. In the Data Validation dialog box, on the Settings tab, select the type of alert you want in the Alert Style list.

Notification Center - When your collaborators start to edit your file, you can receive a notification in the Windows 10 Action Center or in the notification center of your mobile device. Email - You can choose to receive an email notification when a change or comment has been made to your file.

On the Ribbon, click the Data tab, and then click Data Tools. In the Data Tools group, click Data Validation. In the Data Validation dialog box, on the Settings tab, select the type of alert you want in the Alert Style list.