Share With Pals
Like Us
Plus One
Follow Us
Search

Creating Random Numbers in SharePoint Calculated Columns

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