Share With Pals
Like Us
Plus One
Follow Us
Search

Creating Random Numbers in SharePoint Calculated Columns

 Author Mike Smith  Views 2595 View Original Article

  One of my examples for tonight’s Cincinnati SharePoint User Group meeting! See you there!   I wanted to add a "motivational" message to a list of new sales. To be "fair" (i.e. I did not want to think and create a good algorithm!) I wanted the messages to be random. Something like this:    But… Calculated Columns do not support the Excel RAND() or RANDBETWEEN() functions.   So, how to get a
View Original Article

Recent Articles from Tech Training Notes

Date Articles Visits
2017-Apr-13 A SharePoint REST API Tester with an AJAX and Workflow Writer 1189     
2017-Mar-31 SharePoint Date Search Tips #sharepoint #office365 1051     
2016-Nov-17 Creating Random Numbers in SharePoint Calculated Columns 2595     
2016-Nov-16 Using PATCH with PowerShell’s Invoke-RestMethod #PowerShell 1796     
2016-Oct-22 Forest and Trees Problem: "A network-related or instance-specific error occurred while establishing a connection to SQL Server" 1138     
2016-Sep-26 You Can Now Create "Modern" Pages in SharePoint Online 1977     
2016-Aug-20 Hide the Windows Explorer Button in SharePoint Libraries #SharePoint #SharePoint2016 1290     
2016-Aug-19 Auto-populated Choice Columns in SharePoint! #SharePoint 1544     
2016-Aug-18 SharePoint 2016: List View Threshold Limit to Delete a List is 99,993 Items??? #SharePoint #SharePoint 2016 #SP2016 1307     
2016-Aug-15 Get the Version Number of a PowerShell Module 1299