10 digit fixed numeric field

Hi,

I have few fields where I want to add a validation/control user to force doing the correct entry - e.g. PO# shouldn't be more or less than 10 digits. Is it possible? They do these entries via Form.

I see their are new validations numeric/text etc...they don't help what I need.

Also, Can we trigger any flash alert for users- if they feed the wrong one?

Thanks,

Find more posts tagged with

Forms

Formulas

Accepted answers

Arts B.

Thanks, Tim, for replying. Yes, I read more on the community about and found the same workaround....I already applied it.

(my users are floor workers and works in the shift-only issue here is they don't check emails that often.) so this workaround has limitation in this case. But I'll mark this close as, no actual solution available in Smartsheet.

All comments

Tim C

At this time, no it will only validate that it is actually a number (that I'mawarevof). You could have a helper column on the sheet for the form submission, and with a formula or automation. After the form is submitted, the column flags if the form 10k number field matches your criteria or not. Then send an automated update for the corrected 10 digit number. A work around but could work!

Arts B.

Thanks, Tim, for replying. Yes, I read more on the community about and found the same workaround....I already applied it.

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.