Fillable text box isnt show all the information?

Hello,

I am having trouble with the fillable text boxes and i dont know what is wrong. I current have the sheet set up so they fill the form out and whats not working is the commas and last number of the salary wont show up on the final PDF. See below for more detail:

So I am just wondering if I need a helper column to make look right or what but becuase of where this is being sent to it is important to have the "," and the zero at the end. below is my formula process (Its kinda messy):

So i have it say annual salary and then it wouldn't add the $ sign before so i manually entered it. and then originally it just spit the number out with no comma or $.

And then this is where it would fill in.

Please let me know if there is an easier way as well to do this!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!