5

Try using below formula: =IF(ISBLANK([column 1]), true, IF(LEN([column 1])=19, true, false) This will allow users to add either blank values or the text with length of exact 19 characters.


3

Two solutions come to mind... Check for the problem characters: =AND( ISNUMBER(0+[Invoice Number]), ISERR(FIND("$",[Invoice Number])), ISERR(FIND(".",[Invoice Number])), ISERR(FIND(",",[Invoice Number])) ) If the invoice number is a known length, check for the valid characters. This checks the first four ...


2

You need to set the formula value to TRUE in case user selects the "No-Copy". So, try using below formula: =IF([TAtestColumnChoose]="Copy",IF(ISBLANK([Description]),FALSE,TRUE),TRUE) Note: Sometimes comma(,) does not work in formula (I am not sure but it is based on something language on your site). So in that case use semicolon(;) instead of comma(,).


2

Hmm, that's a good question. I had a look around for 10 mins and didn't find something that matches up with what you want, but I did find something you could try to tinker with. @Mike Smith, a well known contributor to this site, has an interesting post on Date fields - see here. If it were possible to combine both of the formulae Mike has posted below ...


2

SharePoint OOTB Solution: Use Column Validation: Go to your list settings. Click on your text column. Move to column validation section and enter below expression: =LEN([your column name])>24 And you can enter some message in user message section. JavaScript Approach: Try using below code: Assuming the display name of your field is "IBAN(24 Digits ...


2

You can add the same formula in list validation settings to show an error and don't allow users to save the form: Follow below steps: Go to You SharePoint list. Then go to List settings. Click on Validation Settings. Add same formula in Formula section. Then add suitable error message according to your requirement in User Message section. Click Save. ...


2

Try this: =IF(LEN([YourColumn])=9,IF(MID([YourColumn],6,1)=".",IF(ISNUMBER(VALUE((MID([YourColumn],1,5)))),ISNUMBER(VALUE((MID([YourColumn],7,3)))),FALSE),FALSE),FALSE) First it validates if it's a 9 character string or not, then checks if the 6th character is a dot (.), then it validates the first 5 and last 3 characters. Of course, it might be ...


1

Added the condition to this formula: ([End Time] is the same day as [Start Time] and allowed limit is 0 hour 15 minutes) =AND(AND(CHOOSE(WEEKDAY([Start Time]),FALSE,TRUE,FALSE,TRUE,FALSE,FALSE,FALSE),IF(OR(TEXT([Start Time],"hh:mm")="12:30",TEXT([Start Time],"hh:mm")="13:15",TEXT([Start Time],"hh:mm")="...


1

Try the below: Assuming [Start Time] at 12:30, 1:15 or 1:30 PM =AND(CHOOSE(WEEKDAY([Start Time]),FALSE,TRUE,FALSE,TRUE,FALSE,FALSE,FALSE),IF(OR(TEXT([Start Time],"hh:mm")="12:30",TEXT([Start Time],"hh:mm")="13:15",TEXT([Start Time],"hh:mm")="13:30"),TRUE,FALSE))


1

Looks like there is one additional ) in your 2nd formula. It should be like: =AND(LEN(Route)=7,MID(Route,4,1)="-",CODE(UPPER(MID(Route,1,1)))=CODE(MID(Route,1,1)),CODE(UPPER(MID(Route,2,1)))=CODE(MID(Route,2,1)),CODE(UPPER(MID(Route,3,1)))=CODE(MID(Route,3,1)),CODE(UPPER(MID(Route,4,1)))=CODE(MID(Route,4,1)),CODE(UPPER(MID(Route,5,1)))=CODE(MID(...


1

I don't think you can validate this column using calculated formula to meet the requirements. Because, the length of the column value is dynamic, and none of the followings could be validated dynamically: LEN([NOTIFICATION NO.])=9 MID([NOTIFICATION NO.],1,3)="500" ISNUMBER([NOTIFICATION NO.]+0) However, if we know the maximum number of semicolon-...


1

Don't use IF() in the validation formula. Use a formula that results in TRUE or FALSE, but not with IF(). You may want to test each component first before you plug them all together into one big formula. Are you certain that EQUALS() even is a valid function in this context? I've never come across this before. SharePoint formula syntax for this scenario is ...


1

Try using this formula: =OR([ActionDate] > DATE(YEAR(Today())+2,MONTH(Today())+6,DAY(Today())),ISBLANK([ActionDate])) Validate Due Date less than 12 months


1

We could use flow in SharePoint online to accomplish your requirement: My test List: My flow: Compose function as shown below: split(triggerBody()?['ColumnA'],'-')?[0] split(triggerBody()?['ColumnA'],'-')?[1] split(triggerBody()?['ColumnA'],'-')?[2]


1

Try using below formula in column validation: =IF([Number Column] = ROUND([Number Column], 0), true, false) Note: Sometimes comma(,) does not work in formula (I am not sure but it is based on something language or regional settings on your site). So in that case use semicolon(;) instead of comma(,). Replace [Number Column] in formula by display name of ...


1

You could add this to your column validation(change the number to your column name). =number=ROUND(number,0) Test result:


1

Try something like below: =[Date Column] > DATE(YEAR(Today())+2,MONTH(Today()),DAY(Today())) Read more about column validations in SharePoint at: SharePoint Online List Column Validation Examples.


1

SharePoint Column Validation Examples for your reference: https://techtrainingnotes.blogspot.com/2015/10/sharepoint-column-validation-examples.html


1

You need change the validation formula to this: =TEXT([Data documento],"yyyy")="2018" Try to use this in list validation. Go to list settings-> validation settings:


1

Per my test, I can reproduce your issue in my environment. You could try this workaround: 1.Create a calculated column, and use this formula : =[Start Month]-[Created] 2.Change the list validation to this: =AND([calculated]<30,[calculated]>-30)


1

This is not possible in SharePoint Online using OOTB capabilities of SharePoint. However there are some workaround to achieve this: Create an Event receiver to check the file type before uploading it to Document library like given at: Restrict File Types in SharePoint Document Library Upload using Event Receiver. Create a Microsoft Flow which will check ...


1

You can use AND or OR to add two formulas together, choose one as your requirement. If you are not sure, you can provide the two detail formulas and requirement.


1

Without knowing the formulas (maybe there are problems in them) I can only suggest to put them in brackets. Following your example, it should be: =(formula 1) AND (formula 2)


1

It has to be in below format for logical operations AND and OR Column 1 - 15 Column 2 - 9 Column 3 - 8 =AND([Column1]>[Column2], [Column1]<[Column3]) - Is 15 greater than 9 and less than 8? Value -(No) =IF(AND([Column1]>[Column2], [Column1]<[Column3]), "OK", "Not OK") - If 15 is greater than 9 and less than 8, return "OK". Value ...


1

Working forumla: =IF(AND(NOT(ISBLANK([My Text Field])),NOT(LEN([My Text Field])=3)),FALSE,TRUE)


1

I needed clarification, but if my assumptions/interpretation was correct I think this should work: =AND( DATEDIF( [Permit Start Date], [Permit End Date], "d" )>=0, DATEDIF( [Permit Start Date], [Permit End Date], "d" )<=14, DATEDIF( [Permit Start Date], [Extension End Date], "d" ...


1

This should, in theory, work. Sorry if it looks a bit daunting but what it's supposed to do is copy the event handler for both save buttons (in the ribbon and on the page body) and replace the "onclick" event with your custom function which in this case I called isUserAllowed. isUserAllowed is a bit more complicated that it normally would because we have to ...


1

Use =[Review Date]>TODAY() in column validation. Tested for Date after Today's date. it is allowing to submit item. Result:


1

If you are using list validation, which works in both classic and modern experience on SharePoint Online, then this is the formula you want: =AND(AND([Date Closed]>=[O365 Queue],[Date Closed]>=[Start Date]),[Date Closed]>=[Create Date]) Make sure to provide users a clear message on why the validation fails, something like: The 'Date Closed' ...


Only top voted, non community-wiki answers of a minimum length are eligible