Forum Discussion
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 then "Yes"
else if [Result]="Approved" then "Completed"
else "Not Completed"
However in the Result whereever Result is Approved, it Error in the new custom column. Other If results are fine.
Results is Text coulmn. Please suggest how to make this if statement work else if [Result]="Approved" then "Completed"
6 Replies
- dufoq3
Community Champion
Hi, are you sure that you have boolean values true or false in [Required] column? In my opition you have text values "true" or "false" there. If I'm correct, this should help you:
if [Required]="true" then "Yes" else if [Result]="Approved" then "Completed" else "Not Completed"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
Provide at least screenshot od your data - mentioned columns and screenshot of error please.
Expression.Error: We cannot convert the value null to type Logical.
Details:
Value=
Type=[Type]
This is the error.
mahenkj2Solution Sage
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.
