Rounding as a column formula

mhtaylor

mhtaylor ✭✭

02/06/25 in Smartsheet Basics

I am trying to set up a column formula to round to the nearest whole number. Anyone know how to do this or if it is possible?

0 ·

Best Answer

Michelle Choate 2 Community Champion

02/07/25 Answer ✓

=ROUNDUP(Number@row,0)

Michelle Choate
michelle.choate@outlook.com
Always happy to walk through any project you need help with! Book time with me here: https://calendly.com/michelle-choate
1 · Share on Facebook Share on Twitter

Answers

Michelle Choate 2 Community Champion

02/07/25 Answer ✓

=ROUNDUP(Number@row,0)

Michelle Choate
michelle.choate@outlook.com
Always happy to walk through any project you need help with! Book time with me here: https://calendly.com/michelle-choate
1 · Share on Facebook Share on Twitter

Categories

Trending in Smartsheet Basics

New User..
Hello, I am a new user to Smartsheet and have a question on Saved Automation Workflows. I am trying to edit the email by adding a due date in the subject line of the email once it reaches a trigger date. Please advise on how I can change the due date from month.
auto-resend update (or approval) request after 30 days
I have some automations set up where the work is intensive (or people forget) and update (or approval) requests sit for more than 30 days. The notification center wipes these requests out after 30 days and although they sit in email, people seem more likely to completely forget about these completely. Does anyone know a…
Adding Contacts To Contact Columns
In an individual SmartSheet that I'm setting the "Column Type" as a "Contact List", is there a way to add all of my SmartSheet contracts to that drop-down list without individually select folks one at a time? Same goes for "sharing". I want to share sheets with my whole operation (75+ people), but having to individually…

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