Hello, I want to be able to round up a number to the nearest whole - for example 4.1 would round to 5, 4 would stay as 4
5.6 would round to 6. any whole numbers would not round but stay the same.
I think that adding .49 (you may need to expand that however many decimals you might work with) to the number within the round formula will always round up.
I have heard of .5 but that would make an integer round up to the next one which won't do.
Round( x + .49)
4.5 rounds to 5
5 rounds to 5
5.01 rounds to 6
5.49 rounds to 6
Is that what you are looking for?
Depending on the significant figures, 0.49 may not work (for example, 0.001 wil give incorrect answer)
This works for all significant digits.
=IF(Owner@row > INT(Owner@row), +1, 0) + INT(Owner@row)
If the numbers are negative and need to increase in magnitude (instead of rounding 'up'), that is a different problem, which I doubt applies here.
excellent thanks so much for your reply, this is great!
Looking to connect a dynamic view of HR dataset to a Power BI dashboard pulling information from multiple other sources. Appreciate any guidance, thanks
Hello! I copied a form I had made for a similar event I am working on now. I made minor adjustments to the form to match the needs of the event. I distributed the form for people to complete, so the form is active, but the data is not populating onto my Smartsheet. Please advise. I would prefer not to have people redo the…
Hello, when I modify a start date on a task I lose the predecessor links. Is there a method to modify task start dates without losing the links? THANKS.
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.