Issues with Normalized name Formula: Empty Rows and Uppercase Names

·

Hey there, got a problem with a "Normalized name" formula: I've shared my prompt. My problem is that i get a lot of empty rows, + some of the names are still full uppercase like JENNIFER. When i prompted it to NEVER do that. what have i done wrong? Company tabe: https://app.clay.com/workspaces/261880/workbooks/wb_JxZfE3e8m6gM/tables/t_3YYgd98KZ2Gz/views/gv_U5odt54FNxEY

· Sorted by Oldest

Gautam Kumar
·
·
what is the formula showing up below after you click on Generate formula
Gautam Kumar
·
·
this works fine
Amir Dawoud
·
·
thx!
Gautam Kumar
·
·
for empty rows you may need to check if you got space in front of name
Tanvi (Clay)
·
·
Hey Amir, thanks for reaching out! Appreciate you jumping in Gautam to support here. I just checked your Normalized name formula column Amir and it looks like its running successfully, great job on your revised prompt! Is there anything else I can help you with?
Channeled
APP
·
·
Hi Amir Dawoud! This thread was recently closed by our Support team. If you have a moment, please share your feedback:

Gautam Kumar
·
·
what is the formula showing up below after you click on Generate formula
Gautam Kumar
·
·
this works fine
Amir Dawoud
·
·
thx!
Gautam Kumar
·
·
for empty rows you may need to check if you got space in front of name
Tanvi (Clay)
·
·
Hey Amir, thanks for reaching out! Appreciate you jumping in Gautam to support here. I just checked your Normalized name formula column Amir and it looks like its running successfully, great job on your revised prompt! Is there anything else I can help you with?
Channeled
APP
·
·
Hi Amir Dawoud! This thread was recently closed by our Support team. If you have a moment, please share your feedback: