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!
From my research, I understand there isn't a way to keep formulas when exporting from Smartsheet into an Excel document. I have a total of 50 columns with formulas and would think there was a quicker way to grab the formulas. So far, I've appended a "!" which turns the formula into text which does export. However, I'm not…
I currently have 14 sheets with the following columns: Batch # and Reviewer I use an Index Distinct formula to acquire the unique batch numbers from all 14 sheets and put them into 14 columns on the 'metrics' sheet. I then use another index distinct to get a list of all the unique batch numbers into one 'Unique Batch…
Hello, I am looking for formula help where I want to return the earliest date in a range for different workstreams groups on a project. The source sheet is formatted as a date field, and the formula used below is returning a 0 no matter what I do. Any suggestions? =MIN(COLLECT({Project Plan - start date}, {Project Plan…
