1

Any help with this would be really appreciated!

I have 2 columns both of type number (OrigDensity and TestDensity). I would like to validate as a user inputs TestDensity it must be +/- 0.05 of OrigDensity (i.e. data from same row).

From online readings, the following approach appears best but just am struggling with syntax I think.

I am using:

IF ([TestDensity] >= ([OrigDensity] - 0.05), AND [TestDensity] <= ([OriginalDensity] + 0.05) ,TRUE)

1 Answer 1

0

In case of both the columns are required in your SharePoint list, try using below simple formula in List validation settings:

=AND([TestDensity] >= ([OrigDensity] - 0.05),[TestDensity] <= ([OrigDensity] + 0.05))

You can find the detailed steps to add list validation formula in my answer at: List validation if then syntax


Notes:

  1. Sometimes comma(,) does not work in formula (it is based on language or regional settings on your site). So in that case use semicolon(;) instead of comma(,).
  2. Use correct display name of your SharePoint columns in above formula.
  3. Wrap column names inside [] if your column name has space in it. For example: [My Column Name].
3
  • 1
    Suggested formula works - thank you so much!
    – Dieter
    Feb 2 at 6:23
  • You're welcome, I am glad it worked for you. Feb 2 at 6:40
  • Please accept my above response as an Answer as it helped you & it will help others with similar question in future to find the correct answer easily. Keep using this platform for asking any questions related to SharePoint, thank you! Feb 2 at 6:41

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.