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
Hello, I'm working through the writing formulas optional activity and in the 'Nested IF function - Progress Column' task it directs you to put in the following formula '=IF([% Complete]@row = 0, “Empty”)'. However, when I put this formula into the spreadsheet, '04a_Marketing Request Tracker - Formulas', I get an…
Have any of you created a Smartsheet that would show the savings for a project by the month? In other words, if I saved $1200 annually and the project ended in say March, then the savings would go $120 per month, Mar 2025-Feb 2026. I have done it on Excel sheets manually, but I think there should be a way to do it with…
I have had approval workflows and notifications built into a couple sheets for about a year now. In the past month, I am getting a lot of feedback saying people did not receive the email request for approval or notification email. It isn't all the time, just sometimes and there does not seem to be a pattern on which ones…
