SharePoint/Excel

Closed
Report
Posts
2
Registration date
Wednesday June 26, 2013
Status
Member
Last seen
July 1, 2013
-
 LynxDeuxJynx -
Hello,

I am trying to create an If function where the Date field must = 2013. I have that

=YEAR([column 1])=2013

But when the field is null it it still sends the error so I tried this:

=IF([column 1] <>"",TRUE, TRUE)

Which works for when it is null, and allows it to pass... but when I try to combine them It's not working. Can you tell me the correct formula for SharePoint 2010 to require users to input a 2013 date and allow it to be null. I've tried this but it doesn't work...

=IF(YEAR[column 1]=2013, IF(column 1] <>"", TRUE, TRUE)

Does anyone have the solution?

2 replies

IF(OR(YEAR[column 1]=2013, IF(column 1] <>""), TRUE, FALSE)
0
Posts
2
Registration date
Wednesday June 26, 2013
Status
Member
Last seen
July 1, 2013

This doesn't work. It says this formula is not supported...

I'd like validation for a column. The validation should say, the year must be 2013 but only if the field is not null
0
Two questions:

1. Is it the entire column or just cell A1 that has to be validated?
2. What does the actual formula look like with the actual ranges inserted?

A test example (with ranges) would help solving your query.
0