SharePoint list validation formula error
Hello. I am trying to use the list validation setting in SharePoint online to validate conditions on a list item before letting a person save changes to it. I keep getting errors. The first part of the formula checks to require responses if the user selects a specific dropdown from the choice column "Confirm". The second part of the formula should check a single line text column called "Location" for a value, and confirm that value doesn't exist in the string of another dropdown column called "Choices". What am I doing wrong? Is what I'm trying to do not possible with a list validation setting? =AND(IF([Confirm]="I request a different location",IF(OR([Choices]="",[ Rationale]=""),FALSE,TRUE),TRUE),IF(OR([Location]="A",[Location]="B",[Location]="C"), FIND ([Location],[Choices],1)=0, [Choices] <>[Location])) Thanks in advance for the insight.
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.
