Rounding to nearest 0.5

Kate Kelley

Kate Kelley ✭✭✭✭

04/07/21 in Smartsheet Basics

Is there a way to have a column round down to the nearest 0.5 increments? Never up though.

If 1.7, would round down to 1.5

If 2.3, would round down to 2.0

0 ·

Best Answer

Paul Newcome Community Champion

04/07/21 Answer ✓

Check out the ROUNDDOWN function.

CERTIFIED SMARTSHEET PLATINUM PARTNER
10xViz.com
0 · Share on Facebook Share on Twitter

Answers

Kate Kelley ✭✭✭✭

04/07/21

Found the answer using the Floor formula

0 · Share on Facebook Share on Twitter
Paul Newcome Community Champion

04/07/21 Answer ✓

Check out the ROUNDDOWN function.

CERTIFIED SMARTSHEET PLATINUM PARTNER
10xViz.com
0 · Share on Facebook Share on Twitter
Kate Kelley ✭✭✭✭

04/07/21

Thanks again Paul!

0 · Share on Facebook Share on Twitter
Paul Newcome Community Champion

04/08/21

Happy to help. 👍️

CERTIFIED SMARTSHEET PLATINUM PARTNER
10xViz.com
0 · Share on Facebook Share on Twitter

Categories

Trending in Smartsheet Basics

Is the Workspace Panel only visible to individuals that have access to the entire workspace?
I'm wondering if I only grant permission to a handful of assets within a workspace to an individual, if that individual will have the workspace panel functionality.
Is it possible to show one row per brand in my report?
Is it possible to show one row per brand in my report? i only want to show here is the what is the latest
Email assigned user
Hello, I'm trying to set up an automated email to my team when they are assigned a task. I have been trying to follow the automated workflow, but it seems I can only assign 1 person for alerts? How can I ensure if "Abby" is selected, Abby is emailed she has a new task assignment. And if "Bob" is selected next, he would be…

Help shape the future of Smartsheet.
Share your ideas and feature requests.