Remove Extra Decimals When Not Needed
I have a column that lists project numbers. Some project numbers have "point numbers" which are shown as two decimal places. The problem is I need the projects that don't have point numbers not to show the ".00" after them. Is it possible to do this?
This is an intake sheet for Control Control Center, and the value is populated by a form, so I'm not sure formulas would help even if that is an option.
Thanks for the help!
Answers
-
Hi @coryg
Hope you are fine, you can use the following formula to do that:
=SUBSTITUTE([MBI Project #]@row, ".00", "")
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives