Sign in to join the conversation:
Hello,
Is there any way to take the decimal and cents out of numbers without smart sheet automatically changing it to what it thinks it should be?
i.e.
9,250,000.00
I would like it to read9,250,000
Thank you
Hi Danielle,
The easiest way to format this is using the decimal level buttons on your toolbar (left side). More info on different formatting options can be found in the help center: https://help.smartsheet.com/articles/518246-formatting-options
I am looking to have my sheet track the number of days remaining after a beginning date entered in a column (labeled Conversion Date). I need to know how many days are left from a total of 90 days.
Today Mar-18, I've lost all my tasks in gantt view, but they are still visible in card view or grid view. Yesterday i've shared the sheet with the team with view only access. Did anyone have similar issues? and how to resolve this?
I just started using the Table View for lists of contacts. I added a Format Rule that would highlight the entire row (except the Email Address field) if the Email Address cell is "blank". A second rule highlights just the Email Address cell itself in a slightly darker color if Email Address cell is "blank". This gives a…