Forum Discussion
Column validation based on choice value of another column
Hi, a citizen developer here... I'm making a simple petty cash log for monitoring cash deposits and withdrawals, which would live as a list or one day a powerapp in MS Teams. I am thinking of usi...
ganeshsanap thank you for your reply! I looked up your linke and some additional examples but I'm now struggling with the sytnax... I need to monitor if "Tip transakcije" column value is (Izdatek/expense), then the "Znesek" column value should be negative.
This is my attempt:
=IF(AND([Tip transakcije]=Izdatek, [Znesek]<0), "OK", "Znesek for Izdatek should be negative")
Could you please take a look? Thanks for your effort!
This is my attempt:
=IF(AND([Tip transakcije]=Izdatek, [Znesek]<0), "OK", "Znesek for Izdatek should be negative")
Could you please take a look? Thanks for your effort!
allyazz Use your formula like:
=IF([Tip transakcije] = "Izdatek", IF([Znesek] < 0, true, false), true)
Use correct display name of "Tip transakcije" & "Znesek" column in your formula. Also, you have to provide error message in User Message text box on list validation settings page & not within formula.
Note:
- Sometimes comma(,) does not work in formula (I am not sure but it is based on something language or regional settings on your site). So in that case use semicolon(;) instead of comma(,).
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.