How to format numbers in cells to show thousands separator and two decimal places. I tried to search , could not find any thread about this. Someone please help. I am new to smartsheet.
Hi,
In the toolbar, there is a .00> button (the button furthest to the right) where you can increase the decimal.
Hope that helps!
Have a fantastic weekend!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
Many Thanks Andree and yes that was easy to do after you showed me how. Nice tip.
Great!
Happy to help!
Andrée
This works for formatting a column but when using join to merge column data I haven't found a way to format a number inline in a formula like you can do in excel.
Can you explain in more detail what you mean? Maybe provide some examples of what you are trying to accomplish?
Oh. My. God. I have brought mapping data into Smartsheet, only to see my X and Y coordinates be rounded down from 13 decimal places to FIVE. Are you KIDDING ME? Those numbers MEAN SOMETHING! Is there a setting somewhere to expand the max????
Hi @Suzanne Raphael
Can you share some examples of the numbers you're using?
Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)
I hope that helps!
Be safe and have a fantastic week!
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
My product/use case: I seek to build a camera inventory. Each camera has a unique identifier. Cameras are mobilized to different locations on different days. I need help making a VLOOKUP or equivalent combination of formulae functions to run 2 queries cross-referencing 2 grids, searching a column with multiple dropdown…
Hey, Is anyone else facing this issue in the approval notifications sent through smartsheet
I have a sheet with a list of customers in one column, and then the following columns are City, Monday, Tuesday, Wednesday, Thursday, Friday. I need help with a formula that I can put in my sheet summary so that if the customer column says Staples (It can say this in multiple rows) that it will tell me the total package…