Techtrainingnotes.blogspot.com Website Review

mike smith's tech training notes sharepoint, powershell and .net! sharepoint, powershell, .net and other stuff i spend too much time on.. 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 of the following as*ume that you have a single line of text or choice column named month.            upper(d2),                ,jan,feb,mar,apr,may,jun,jul,aug,sep,oct,nov,dec) find returns the position of the matching text. jan returns five. if we subtract one and then divide the find number by four, we get the             upper(month),                      ,january  ,february ,march    ,april    ,may      ,june     ,july     ,august   ,september,october  ,november ,december  this uses the same idea, but the month names are spelled out and are padded with spaces to make each one nine characters long. (ten with it only took me a year… and it grew from a little booklet to over 200 pages… but its finally done! understanding of how sharepoint formulas work, where they don’t work, and how they are created. while at first glance sharepoint formulas appear to be simple calculations, they are both quite powerful and have weird limitations. in this book we will explore the basics of creating calculated columns and validation formulas with some boring details, and over one hundred examples. we also explore workarounds for many of the limitations by using sharepoint designer workflows and a few tricks!   over 100 examples! a how-to book of formulas would not be too useful without a few examples. i've been collecting these for years. they've come from clas*room questions, “workarounds” for things sharepoint formulas can’t do scroll on down for a complete list of the examples. anyone who creates and customizes lists and libraries. these include: sharepoint on premise fa*m administrators, office 365 sharepoint