Share With Pals
Like Us
Plus One
Follow Us
Search

Creating Random Numbers in SharePoint Calculated Columns

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