Forum Discussion

SamWhite's avatar
SamWhite
Frequent Visitor
2 years ago

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 ...
Need Help
SamWhite's avatar
SamWhite
Frequent Visitor
2 years ago

Expression.Error: We cannot convert the value null to type Logical.

Details:

Value=

Type=[Type]

 

This is the error.

mahenkj2's avatar
mahenkj2
Icon for Solution Sage rankSolution Sage
2 years ago

As error suggests, your that column is having nulls, and we may be testing it for some value.

 

Compare with my sample data, check, else share a sample data pls.