I am looking for a formula to derive numbers in words from another column containing the numbers. Eg

leeziervogel

I am looking for a formula to derive numbers in words from another column containing the numbers. Eg Column 1 - 305 Column 2(formula) - Three hundred and five 

Andrée Starå

Hi @leeziervogel

I hope you're well and safe!

Can you elaborate more on what kind of numbers and what structure it should have?

Can you share some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help.

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

leeziervogel

Hi Andree

Please View example here https://app.smartsheet.com/b/publish?EQBCT=8ed9a6976fb74178a30ae4281c6e4285

Andrée Starå

@leeziervogel

I can't access the sheet.

leeziervogel

Heres a screen shot

thanks !

Andrée Starå

@leeziervogel

Happy to help!

Are you open to integrating it with a 3rd-party service like Zapier? I developed something similar for the translation of numbers to different languages.

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

leeziervogel

I would prefer something simpler, what does Zapier integration entail?

Andrée Starå

@leeziervogel

You'd need an account to set up the integration so it works.

Also, there are AI features coming from Smartsheet that might solve it, too, but I am not sure when they will be released for general access.

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!