Share With Pals
Like Us
Plus One
Follow Us
Search

Creating Random Numbers in SharePoint Calculated Columns

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