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!
Hello, I have 2 date columns. I put a test sheet together for a visual reference. The Date 2 column needs a formula to calculate whichever date 39-45 days out is a Friday. Any help would be greatly appreciated.
Is there a way to display for one specific columns cell history display in another column for calculation purpose? I wanted to count each stage from one specific column by getting cell history in separate column to calculate duration. Thank you!
I want to use a list of account numbers in one sheet for a dropdown in another sheet using Table View. When I select the sheet and column in the dropdown menu, it shows the correct column but is dropping zeros. I have provided a screenshot of the reference column and then what appears in the drop down. Any ideas?
