Pages

▼
Showing posts with label SharePoint 2016. Show all posts
Showing posts with label SharePoint 2016. Show all posts
10/30/2018

SharePoint Calculated Columns – Convert a Month Name to a Number

›
Here are three solutions for when you have a column with a three letter abbreviation of a month name, and you want the month number, Each o...
10/15/2018

SharePoint Calculated Columns and Validation Formulas – The Book!

›
Available on Amazon! It only took me a year… and it grew from a little booklet to over 200 pages… but its finally done! Bought the book? ...
9/06/2018

SharePoint Dates are Always Date AND Time

›
A Quick SharePoint Date Tip! When you create a Date column you have the choice of Date and Date & Time.     Note the keyword “Format” i...
4/20/2018

The Mysterious Semicolon in SharePoint Search

›
Discoveries: A semicolon in a search is the same as the keyword "AND". You cannot uniquely find text that contains a semicolon. (...
4/07/2018

SharePoint TEXT() Function Bug for Scientific Notation

›
In Excel you can use the TEXT function to display very large and very small numbers in scientific notation. TEXT([Number],"0.00E+00&qu...
3/29/2018

Shorter SharePoint Calculated Column OR Statements

›
Tested in SharePoint 2010, 2013, 2016 and Online. Available on Amazon! Array Constants Excel will often let you use an array of values w...
3/26/2018

Adding Fractions (1/4) to SharePoint Calculated Columns

›
(The following works SharePoint 2010, 2013, 2016, SharePoint Online, and most likely, 2019!) 0, 1/8, 1/4, 3/8, 1/2, 5/8, 3/4, and 7/8 Th...
3/08/2018

Adding Roman Numerals to SharePoint

›
In a Calculated Column Assuming an integer in a numeric column named the "TheNumber", just add this equation to a Calculated Col...
3/07/2018

A SharePoint Calculated Column for all 50 States (workarounds for nested IF limits!)

›
Just in case you might ever need a formula to convert state abbreviations into state names… You will need 50 nested IFs, but SharePoint...