I am working on a SharePoint list validation to automate some process.
I have Column A which is a Yes/No type column and I have Column B which is a calculated column that will take input from column A.
A simple example:
Column A | Column B
Yes | 1
No | 0
But when I use the formula for Column B as below the result is always 0:
=IF(ShipmentRequired="Yes",1,0)
It also shows the same result when I try to change the formula as below:
=IF(ShipmentRequired=1,1,0)
The result will always appear as 0 as it doesn't identify the input in Column A.
Column A | Column B
Yes | 1
No | 0
Any help would be much appreciated.