Hi Pigment team!
Is there a formula to look for the names dimension name in the Memo, and populate the EE dimension in the new property? Thanks in advance!!
![](https://uploads-eu-west-1.insided.com/pigment-en/attachment/4021cb50-0d98-45eb-8f6f-edc438d524b3.png)
![](https://uploads-eu-west-1.insided.com/pigment-en/attachment/e4d94db7-e2dd-44f2-b3dc-b5f0b97022ba.png)
Hi Pigment team!
Is there a formula to look for the names dimension name in the Memo, and populate the EE dimension in the new property? Thanks in advance!!
Hi,
You can probably cut the string by FIND() the Month (Aug 23 here, but you’ll have to search for each month), then LEFT() from the result of the find, gives you the name.
Then you can use ITEM() to match the name vs the Employee dimension, which should give you your employee usable for summing values onto it.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.