Forum Discussion
AND-OR on New Column
Hello ezequiel
Not sure about the syntax of your AND / OR
The correct syntax is : AND(X;Y) / OR (X;Y)
Maybe try to add a new column and then type in :
Column = IF(AND([Compliant Request]="NO";OR([Request Status] = "Pending";OR([Request Status] = "Assigned to";OR([Request Status] = "Processing";OR([Request Status] = "Pending Approval";OR([Request Status] = "On Hold";OR([Request Status] = "Pending DocuSign";[Request Status] = "Pending Recipient Information")))))));"NO";"YES")
Not sure about the result matching what you are looking for (we need more details to help you)
EDITED 16h24
Hi ezequiel ,
Please check if there're some unprintable characters in your column. Use trim to remove those character and try again.
Regards,
Jimmy Tao
Hi Jimmy...I checked and there are not unprintable chars. Any other suggestion? Do you see any issue on the logic I built?
Thanks,
Hello ezequiel
Not sure about the syntax of your AND / OR
The correct syntax is : AND(X;Y) / OR (X;Y)
Maybe try to add a new column and then type in :
Column = IF(AND([Compliant Request]="NO";OR([Request Status] = "Pending";OR([Request Status] = "Assigned to";OR([Request Status] = "Processing";OR([Request Status] = "Pending Approval";OR([Request Status] = "On Hold";OR([Request Status] = "Pending DocuSign";[Request Status] = "Pending Recipient Information")))))));"NO";"YES")
Not sure about the result matching what you are looking for (we need more details to help you)
EDITED 16h24
