I need to write a list validation formula. I have a column named type of change that is numbers that is mandatory if other column dollars is filled.

Thank you

1 Answer 1


Use List Validation formula like below:

=IF(ISBLANK([Dollars]),TRUE,IF(ISBLANK([Type of change]),FALSE,TRUE))

Use steps given in this thread to add list validation formula: List validation if then syntax


  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 names of your columns in the formula.
  • I’m checking how the things are going on about this issue. Did Ganesh Sanaps' answer help you?
    – Xyza_MSFT
    Commented Apr 24, 2023 at 9:46

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.