Custom Data Validation: Formula result is correct, but the cell won't allow the correct result?

[gravanoc]

I may be misunderstanding the arcane art of custom formula data validation. I have a column that should only accept the name of its tab as valid data. I use the formula:

=MID(CELL("filename",D2), FIND("]",CELL("filename",D2))+1,100)

The result is indeed what I am looking for from the formula, but when I use it as a custom data validation formula, it rejects the desired answer.

 

[Peter_SSs]

If you are trying to put that DV into cell D2 then you need to include this in the custom DV formula.


=D2=MID(CELL("filename",D2), FIND("]",CELL("filename",D2))+1,100)

 

[gravanoc]

If you are trying to put that DV into cell D2 then you need to include this in the custom DV formula.


=D2=MID(CELL("filename",D2), FIND("]",CELL("filename",D2))+1,100)

Thanks!

 

[Peter_SSs]

You're welcome.