This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have a data set where i am trying to update particular values thats missing manager name as per those values in the same column that include a manager name.
SALES 1 (BOB)
In the above table, i want to update the values "SALES" to "SALES (ROB)" or FINANCE to FINANCE (John) . How do i do this. I tried splitting the columns but i am unable to get the manager name associated to the rows where the entry is missing.
Hey @sr49ers! Try using the attached workflow. The key was to use a Filter then a Formula and the Find and Replace tool. You could also replicate this if you wanted to perform the same actions to the Level 3 field. Does this work for your purposes?