How do a require a form to submit a rounded number to the sheet?

I have a data sheet (and reports) that round numbers to the nearest whole number. However, as people use the form to enter data, when the data appears on the sheet, it is not rounded, and the unrounded number propagates onto the reports and dashboards.

Is there a setting somewhere to maintain the "rounding" setting? Currently, I have to remember to go into the sheet every day and reformat the column to drop the decimal places.

Find more posts tagged with

Accepted answers

All comments

KPH

You could separate the entered date from the clean data in two columns. Pop a ROUND function (or similar) in the clean data column to do the rounding for you automatically. Make this a column formula so you can forget about it. Use that column in your reports/dashboards. Hide the column the user enters via the form.

Stephen_at_ODOC

Hm. That would work. But would leave me with like 50+ "helper columns". If that's my only alternative, I'll go that route, but I'll give it a week to see if anybody else has a magic method :)

KPH

🤞

Amit Wadhwani

https://community.smartsheet.com/discussion/comment/453790#Comment_453790

I am curious why you will have 50+ helper columns? Let's assume that the "User Input" column contains decimal and you use ROUND function (=ROUND([User Input]@row, 0)) in a column "Input Rounded Off", you don't need additional columns.

Stephen_at_ODOC

https://community.smartsheet.com/discussion/comment/453868#Comment_453868

Because the user-input is about 50 data points. It's a list of results from a chemical analysis; so. the user inputting the 50 results of each of the 50 different chemicals. Each data point is its own column. If I need to round that data point, I would need a column for each of my existing columns, right?

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.