Welcome!

Rounding up if over .5 and rounding down if .4

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!

Emails sent via Automations not working
Hi, My team uses smartsheet to create and notify our team that a user has opened a ticket. We have noticed that emails that are sent via automations are either extremely delayed (several days in some cases) or not being sent out at all. Has anyone else experienced this? Is this an issue on the servers from the issue…
Keep getting Selected data cannot be charted. Please select a new range.
Hello, I am trying to create a chart widget in my dashboard, but I keep getting "Selected data cannot be charted. Please select a new range." error. The report I am using is already summarized in numeric value. What is funny is I have report that I created a chart widget in another dashboard, and when I use that same…
Countifs formula to count based on two columns
I have a picture below for an example of this. I want to create a formula to get counts of items in "Column2", but if "Column4" states "change" I want the "Column2" count to not work and instead count what is it "Column3" in that given row. Column4 can also have several different things in it besides "good" that I want it…