SOLVED

Problem entering a validation formula on a Microsoft list

Copper Contributor

I am trying to enter a formula that would check if the column [EthernetMAC] has any info in it while the [Asset Type] is a Laptop. If [EthernetMAC] has no info in it, the formula should return a false and give out an error. If it has any info, it should return true and allow the user to save the info.

=IF([Asset Type] = "Laptop", IF(ISBLANK([EthernetMAC]), false, true), true)

The [Asset Type] is a choice column, [EthernetMAC] is a single text field. For some reason, the site won't accept this formula due to a syntax error but for the life of me, I can't figure out, where or what the error is.
Can someone explain to me where I've made a mistake?

1 Reply
best response confirmed by f0rumdweller (Copper Contributor)
Solution
Figured out the problem. The logic of the formula was correct, problem was caused by my regional settings. After changing all the , in the formula to ; the site accepted the formula and it worked correctly.
1 best response

Accepted Solutions
best response confirmed by f0rumdweller (Copper Contributor)
Solution
Figured out the problem. The logic of the formula was correct, problem was caused by my regional settings. After changing all the , in the formula to ; the site accepted the formula and it worked correctly.

View solution in original post