Index Match function cuts off zeros
Hello all,
I am pulling a cell value from a different grid with an Index Match function. The cell value is "89.09740".
The value can be pulled succesfully, however, the number is displayed without the zero at the end: "89.0974".
Is there anything I can add to the below formula that would make sure no zero is cut off at the end of the number?
Here is the current formula:
=INDEX({ACC operations tracker all columns base sh Range 1}, MATCH($[Row ID]@row, {ACC operations tracker all columns base sh Range 2}, 0), MATCH([Item Number]$1, {ACC operations tracker all columns base sh Range 3}, 0))
Thanks in advance,
Dennis
Answers
-
Hey Dennis, although there is a 0 - those numbers are the same so It shouldn't matter. However is you want to increase the amount of decimals you see you can edit it like this. (the button to the right is increase decimal and you can add as many 0's to the end as you like).
You can perform this action for the entire column as well.
-
Hi Brucey,
that was it! :D Thanks for the quick fix :)
Have a great day,
Dennis
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.7K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 456 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!