Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
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!
Hi all! I'm working on a column formula that will check whether the Column2ref cell in the current row is blank. If it is blank, the formula finds the maximum value in the ID column where the Trainer Name matches the Trainer Name cell value in the current row and the ID cell value is less than the ID cell value in the…
How do I see who submitted a form for a specific sheet?
Hi, I have a Gantt covering 500+ rows of events past and planned. I use it to predict and track values around these events. Using helper columns to identify the current week, I get an email report on a Monday that tells me the upcoming events in the current week (7 days) and their values. Currently if an event spans…
