Share With Pals
Like Us
Plus One
Follow Us
Search

Creating Random Numbers in SharePoint Calculated Columns

 Author Mike Smith  Views 1399 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 726     
2017-Mar-31 SharePoint Date Search Tips #sharepoint #office365 670     
2016-Nov-17 Creating Random Numbers in SharePoint Calculated Columns 1399     
2016-Nov-16 Using PATCH with PowerShell’s Invoke-RestMethod #PowerShell 1296     
2016-Oct-22 Forest and Trees Problem: "A network-related or instance-specific error occurred while establishing a connection to SQL Server" 710     
2016-Sep-26 You Can Now Create "Modern" Pages in SharePoint Online 1478     
2016-Aug-20 Hide the Windows Explorer Button in SharePoint Libraries #SharePoint #SharePoint2016 916     
2016-Aug-19 Auto-populated Choice Columns in SharePoint! #SharePoint 1123     
2016-Aug-18 SharePoint 2016: List View Threshold Limit to Delete a List is 99,993 Items??? #SharePoint #SharePoint 2016 #SP2016 885     
2016-Aug-15 Get the Version Number of a PowerShell Module 916