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
Add a comment
|
1 Answer
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
Note:
- 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(,). - Use correct display names of your columns in the formula.
answered Apr 19, 2023 at 3:06
Ganesh Sanap - MVP
47.4k22 gold badges32 silver badges64 bronze badges
-
I’m checking how the things are going on about this issue. Did Ganesh Sanaps' answer help you?Xyza_MSFT– Xyza_MSFT2023-04-24 09:46:16 +00:00Commented Apr 24, 2023 at 9:46