Convert numbers to words

JayPedde

Hello,

In an effort to automate our contracting process I am trying to convert numbers to words (preferably dollars and cents) for example $12,345.67 = Twelve Thousand Three Hundred Forty-Five Dollars and Sixty-Seven Cents.

Using Google Doc/Smartsheet Merge I have completed most of the project with ease, however i am stuck in solving the final piece - ultimately i do want the text to be returned to my smartsheet.

Any suggestions would be appreciated

There are many online tools to do the work - one example is below: https://www.calculatorsoup.com/calculators/conversions/numberstowords.php?number=12345.67&format=currency&letter_case=Title+Case&action=solve

Thanks,

Jay

JayPedde

Solved...

I was able to make it work in a roundabout fashion using Zapier, Google Docs and two smartsheets.

1. Add an Auto Row number column to your Smartsheet
2. Intakes information/requets from a Smartsheet Form
3. Zap #1 - Zapier moves the number I want to convert to words and the ROW ID number to a Google Sheet
4. Using Google Sheet "Importdata" Function I reach out to the website that converts numbers to written dollars & cents
5. Zap #2 - Creates a new row and imports the ROW ID number and the written number back to a separate "Refernece" Smartsheet
6. Vlookup from the original smartsheet to the "reference" smartsheet and voila

Google Sheet:

Andrée Starå

Hi Jay,

The third-party service, Formstack Documents (or maybe Zapier), could be an excellent option for this scenario. Is that an option for you?

More info:

https://www.webmerge.me/

I hope that helps!

Have a fantastic day & Happy New Year!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer. It will make it easier for others to find a solution or help to answer!

JayPedde

Hi Andree,

Thanks for responding. I messed around with Zapier for a couple of hours and could get it to work halfway. I can get the Zap out to Google Docs and run the conversion there, but am having trouble bringing the result back into Smartsheet, but I am admitadly a novice at Zapier, so i will keep playing with it.

I have never used Formstack, but my quick review of the info above I'm not sure the the route.

Thanks

Jay

JayPedde

Solved...

I was able to make it work in a roundabout fashion using Zapier, Google Docs and two smartsheets.

1. Add an Auto Row number column to your Smartsheet
2. Intakes information/requets from a Smartsheet Form
3. Zap #1 - Zapier moves the number I want to convert to words and the ROW ID number to a Google Sheet
4. Using Google Sheet "Importdata" Function I reach out to the website that converts numbers to written dollars & cents
5. Zap #2 - Creates a new row and imports the ROW ID number and the written number back to a separate "Refernece" Smartsheet
6. Vlookup from the original smartsheet to the "reference" smartsheet and voila

Google Sheet:

Andrée Starå

Excellent!

Glad you solved it!

I'm always happy to help!

I had an idea that we might be able to something with tables in Smartsheet but it would take some work.

Andrée Starå

To add:

Nicely done! 👍️