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
-
I'm not sure if there's a way to join text strings together and still retain the $ sign and commas
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 422 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 143 Just for fun
- 59 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!