2
votes
0answers
12 views

How do you validate a column only if it's new item being added?

I recently added validation to a field which works great. =[Arrival Date]>=TODAY()-5 However, I ran into an issue when an employee is editing an older item to update the "Status" but it's not ...
1
vote
0answers
27 views

column validation across survey questions

I want to validate responses to a question in a survey using information from a previous question and I just can't get the survey to take the validation formula. Basically: Q1 = How many hours do ...
0
votes
1answer
42 views

SharePoint Column Formula Validation

I need to check if a column (type Number) is an Integer (no decimal). I added this formula to the list validation: =mod([MyField],1)=0 But I get this error: The formula contains a syntax error ...
2
votes
2answers
57 views

Date Format Modifcation in List

I would like to format a new column with the Month and Day of another column. Is there a way to accomplish this? I tried adding this =TEXT([Date of Birth],"MM/DD") in column validation but it gives me ...
1
vote
1answer
60 views

Column Validation

I got 8 columns in my List(calendar reservation). I want to have one column(Approval: YES/NO) only visible to a user("testuser"). How can we use column validation *expressions* to archive this. ...
0
votes
1answer
815 views

Validation formula that TEXT should not to have SPACE

Is there any validation formula which don't allow to save some value in column with SPACE in SharePoint 2010? I know that is Calculate column formula with TRIM formula but I need to validation formula ...
0
votes
1answer
364 views

Date field validation in SharePoint 2007

I need to limit the Date field in a SharePoint 2007 list so the users can enter date from today and up to year after. How can i do it?
1
vote
1answer
602 views

Validation of dates in different fields in sharepoint

My question is on validation of dates in SharePoint… If i have two date fields – start date(& time) and end date(&time). How do i validate these, so that a person cannot pick a time in ...
1
vote
2answers
1k views

How to validate if entered text for a column is in Upper Case

I need to validate if the text entered in a text column is written in UPPER CASE.
2
votes
1answer
8k views

2010 Column Validation Formula

This formula works fine when adding a new list item: =[Class Date]>=TODAY()+3 Basically ensuring the user selects a date greater than two days away from current date. I don't want the formula to be ...
8
votes
4answers
2k views

List Validation does not show Error when Conditions are not met

I am using List Validation feature for a list which is working fine i.e. doesn't save the item when condition not met. However, it is not showing the error message which helps to rectify the inputs in ...
2
votes
2answers
2k views

How to make SharePoint fields mandatory conditioned on other fields?

For example, in a workflow task, I might have a master field called "Approve" which, if set to "No", makes it unnecessary to complete the rest of the form (and thus makes them non-mandatory). Is there ...
1
vote
2answers
221 views

SharePoint List Check whether Value is Checked

I am using Windows SharePoint Server 2007. In a custom list, if I have two columns. One has a list of Categories, and the second has a list of Products. So in my Categories Column its a Choice with ...
1
vote
3answers
2k views

Email validation in SharePoint 2010

We have a column of type "E-Mail" and we'd like to attach validation to it so it conforms to the normal regular expression email validations at a specific domain. Is this possible without writing a ...