Conditional Replace Formula
Team - Wonder if someone can point out where I’m going wrong w/this statement - I have a quota table, one record per person per calendar month. I’m trying to write a statement that says if employeeUID = “EK3913” and Compmonth = “MONTH01” then replace employeeUID for “AR”. The problem w/the below formula is it’s changing all the EMPLOYEE UIDS for EK3913 to AR; versus just the one where the UID is EK3913 and the compmonth is Month01.
Would appreciate any input anyone has - I’m sure it’s simple, but I don’t see it.
Thanks - Ryan
if(and(column(“EMPLOYEEUID”),“EK3913”,(“COMPMONTH”),“MONTH01”) == true)
{
replace(column(“EMPLOYEE_UID”),“EK3913”,“AR”)
}