Thursday, November 12, 2015

Conditional Formatting in SharePoint 2013/2016 and Office 365

Conditional formatting has always been a pain point in SharePoint 2013 and SharePoint Online (Office 365). Especially for those working with SharePoint 2007 and 2010 where you were able to do conditional formatting using SharePoint Designer. In SharePoint 2013 and Office 365 this functionality is gone.

You can still use different JavaScript hacks (i.e. use some calculated columns + JavaScript to apply conditional formatting to the row). There are lots of blog posts about that, but the main problems with all of those are amount of time you have to invest to produce the result and the fact that it is practically out of bounds of the regular SharePoint user.

My company Sharepointalist was diligently working on making conditional formatting features accessible and usable by the regular SharePoint user. We have done an enormous work and I am very proud to showcase some of the features of our new product SharePoint List Booster.
List Booster works as an add-on on your regular out of the box SharePoint list views (any lists and document libraries). It allows you to style your list, apply color schemes, manage font-styles and colors - all on top of you regular SharePoint user interface.

Using List Booster you can easily apply different conditional formatting rules including:

  • Text Rules;
  • Date Rules;
  • Numeric Rules (including currency);
  • Ranking Rules (Top, Bottom, Top %, Bottom %);
  • Averages Rules (equals average, above average, below average, etc.)

You can also use various indicators allowing to create various traffic lights.

Tuesday, June 9, 2015

Resize columns in SharePoint lists and document libraries

User experience in SharePoint is one of the key concerns for many SharePoint users. My company - Sharepointalist decided to upgrade SharePoint user experience in one of the most frequently used SharePoint features - lists and document libraries.

Sharepointalist recently released a new product – SharePoint List Booster. It’s a new generation SharePoint add-on, created using JavaScript and CSS only – no server-side code – works for both SharePoint Online (Office 365) and SharePoint 2013. List Booster enhances out of the box SharePoint user experience enabling user to do the following, when working with lists and document libraries:

  • resize columns (including auto-size by double click) - on any list view;
  • change of font styles, text alignment, color and background for columns and headers;
  • real paging (showing total amount of pages and clicking on the page number same way as in Google), visible both on top and bottom of the list view;
  • table styles color schemes – same as you have in Microsoft Excel or Word;
  • it all works both in regular view and in quick edit mode.

All those features are very intuitive and easy to use by the end users. List Booster helps a lot with the SharePoint adoption and increases performance when working with large lists and document libraries.

You can check out short video about the product at

If you wish to be able to easily change column sizes, text and background colors, font styles and alignment of your SharePoint lists and document libraries, you have to check out this product.

Tuesday, January 13, 2015

Eliminate Confusion with Time Zones in SharePoint Online and SharePoint 2013 On-Premises

Many companies with users spread across multiple time zones experience issues with the dates when using SharePoint on-premises and SharePoint Online. By default SharePoint users see all dates and times in the time zone of the site, so all the visitors has to guess what is the actual time of all those modify dates and event start times. There are multiple ways to eliminate this confusion:

  • Out of the box - Update your user profile to always show SharePoint dates in your current time zone. While being a great feature, it is somewhat hidden from the user and relies on self service (user has to do that by himself)
  • SharePoint Time Zone App - my company (Sharepointalist) recently published new free SharePoint App (works both on-premises and SharePoint online), which allows you to place small widget (app part) on any SharePoint page, and it will show user time zone of that page. It means that when you create a calendar and share the link with all users, they will immediately see what time zone is that in. This app also provides a quick link to configure user profile to see all dates in the right time zone, which is very convenient to the user. Please try this app, it is totally free and very easy to install and use.

Attaching couple screen shots of the app