Pages

▼
Showing posts with label SharePoint Site Owner. Show all posts
Showing posts with label SharePoint Site Owner. Show all posts
3/16/2019

SharePoint Validation Formula Tip – Don't Use IF!

›
I often see questions about SharePoint validation formulas in the online forums that include IF statements to return True or False. Somethi...
2 comments:
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...
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...