ATOI365D#Office365Challenge Oh here’s a good one that I’ve NEVER used before. The ability to set validations on columns in SharePoint – OTB.

Day: 285 of 365, 80 left
Tools: Office 365, SharePoint
Description: SharePoint List Validations
Audience: All

Thanks to Esaie Mpoyi for reminding me of this!

In this example I have a column for Approve – Yes / No. If No is chosen the user should be forced to complete the comments.

I’ve done this by navigating to the List Settings > Validation Settings:


Here I have the ability to add a formula for the validation. If the field value is Yes, it does nothing, if No, it forces the Rejection Comments to be completed. You can also add a customized message at the bottom:


This is what the form looks like when the value of Approve is No. The message appears at the top and does not allow the user to save the item:

Here’s my list, even though the Rejection Comments column is not compulsory – the fields will be completed when necessary.



Overview of my challenge: As an absolute lover of all things Microsoft, I’ve decided to undertake the challenge, of writing a blog every single day, for the next 365 days. Crazy, I know. And I’ll try my best, but if I cannot find something good to say about Office 365 and the Tools it includes for 365 days, I’m changing my profession. So let’s write this epic tale of “Around the Office in 365 Days”. My ode to Microsoft Office 365.
Keep in mind that these tips and tricks do not only apply to Office 365 – but where applicable, to the overall Microsoft Office Suite and SharePoint.