SharePoint calculated column formula in List not consistent
I have a custom column that uses this formula to create a unique ID: =CONCATENATE(Section,REPT(0,4-LEN(ID)),ID) It works fine most of the time, then it seemingly drops the ID value. One thing to mention this ID value is the system generated value found in the ID column of any SharePoint List, not a user created column. So for example the first item has a unique identifier of ABC0001, the tenth has ABC0010 and so on. That worked fine and then i noticed that the unique number for what once was ABC0005 is now ABC0000. If i go to the calculated column and update the parameters in the formula it will update and resume showing the correct value, ABC0005 for this example. Since ID is a system generated value and this formula is embedded in a column what could cause it not evaluate the formula to true and thus the unique ID randomly?Removing full stops from a number sequence
Hi all, We have a single line text column that we use to ID folders. The ID's follow this structure 1.1.2.1.2 Is there a way a calculated field can take this sequence and remove the full stops between the numbers so instead of 1.1.2.1.2 we get a calculated column that returns 11212? Thanks!Column Default Value Based on Root URL
I have a tab in an MS Teams team where users can view our upcoming corporate training sessions (i.e. Events). In each event description, I am putting a link to a sign up form. The sign up form is a list in MS SharePoint Online. In this list, there is a column to specify the event to which the user wants to sign up. I want this column to be automatically filled using the column default value function in SharePoint. The default value would be based on the root URL that led the user to the sign up form. For example, if the user was viewing training session X in Teams, it means the root URL is the event X URL. So, the formula would be: IF [Root URL] = (URL of event X) then "X", ELSEIF [Root URL] = (URL of event Y) then "Y"... and so on. Does this hypothetical [Root URL] function even exist? If not do you have any suggestion for how I can tell which event the user is coming from such that I can fill the column automatically? Thanks.
SharePoint 2013 LIst Filters (by latest date)
I am trying to sort a list by the latest date before a predefined date. I need it to also sort on 2 other columns. Basically I need the last date entered before [Date] for each drop down choice Drop down Column 2 Date End Date - (latest record after a date) I found a few things online but I'm not sure where I would add this or what the best plan of attack would be. Filter(ListName,Date=First(Sort(Distinct(ListName,Date),Result,Descending)).Result) Any help or direction is greatly appreciated.
