Forum Discussion
SamWhite
2 years agoFrequent Visitor
Custom Column String comparison not working
I have excel file which has a column called Result, it has either values of "Approved" or null. I am writing a if function in custom column which is checking few conditions like: if [Required]=true ...
SamWhite
2 years agoFrequent Visitor
The error is not on the boolean value. The error is for the below line:
else if [Result]="Approved" then "Completed"
Where-ever Result is equal to Approved is not resulting in Completed. It gives ERROR is the custom coulmn.
dufoq3
Community Champion
2 years agoProvide at least screenshot od your data - mentioned columns and screenshot of error please.