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:
Hi,
How can I use a formula for rounding up if the number is .5 and higher and round down if the number is .4 and lower?
For example:
2.3 = 2
2.6 = 3
Thanks,
Kelly
You can simply use the Decrease/Increase Decimal, on the top right of any spreadsheet.
Does ROUND( cell-ref, 0) not work?
Craig
--update--
Increase/decrease does not change the value, only what is displayed.
The sum of 2.4 + 2.4 + 2.9 rounded is 8
The sum of ROUND(2.4.0) + ROUND(2.4.0) + ROUND(2.9.0) is 7
Thank you!
Anyway we can make this view only for security purposes? We would like to prevent users from sending responses to other users by accident.
I am currently setting up an automation for people to get notified through their email, when they are prompted. But is there a way that they can reply in the email of a comment that will then go to the specific sheet. This way they do not have access to the sheet, but can just comment through email with updates?
I am extremely frustrated and disappointed with my current Smartsheet experience. I have paid for a Pro subscription, I am the owner and administrator of my account and sheets, and I have confirmed I am logged into the correct account. Despite this, Smartsheet is not recognizing my Pro subscription, and I am unable to…
