Help with a formula!
![System](https://us.v-cdn.net/6031209/uploads/userpics/650/n67RVONBT7K0D.png)
Answers
-
I am working with text and numbers. Somehow, when I put a percentage, in my summary sheet it takes it as a value of a currency and converts it to "0.10 USD$" in te case of "10%". I would like to strictly have all the data in my cells to be taken as text so if I write text, it takes it as it is and if I have a number, it will also take it as it is written so if I write "10%" in the cell, the summary sheet doesnt show me 0.10, or 0.10 USD$.
I dont have a problem adding a helper column to automate my stuff, does this formula =[Number Column Name]@row + "" could work? -
Hi @Santiagogr1
It sounds like there may be some formatting applied to that column and/or cell, could that be possible?
If you click on the column name, see if any of the formatting buttons are highlighted. You'll want to take off the currency setting. This should keep it a s a plan Text/Number column:
Cheers,
GenevieveJoin us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!