Hello,
I have a sheet update task. Where there is a filter on matching of a parameter color.
color = IF( formmultirow5.count = 0 , LOOKUP([PC_PrePackDef.Color] , PC_PrePackDef.unique_id = formmultirow5.ppdefuniqid_epp) , LOOKUP([PC_PrePackDef.Color] , PC_PrePackDef.unique_id = formmultirow5.ppduniqid_cpp))
But this filter is not working. I have marked the " Insert new record if it doesnt exist"
there the color parameter is given the same formul.
The filter doesnt work and a new record is created with correct value in color cell.
SO the formula, is working when updating a sheet record, but not when used as a filter.
IF( formmultirow5.count = 0 , LOOKUP([PC_PrePackDef.Color] , PC_PrePackDef.unique_id = formmultirow5.ppdefuniqid_epp) , LOOKUP([PC_PrePackDef.Color] , PC_PrePackDef.unique_id = formmultirow5.ppduniqid_cpp))
Any suggestions?