Force a format in a cell

We have a form that requires a 10 digit phone number. Clients are not entering the full number, is there a way to have Smartsheet make sure that 10 digits are entered in that cell?

Thank you,


Best Answers

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    There is no way to force a format, but you can use a helper column to check whether or not the format is accurate and then send an alert/update request after the fact.

    If users are entering data directly into the sheet (as opposed to through a form), you can use the same helper column and set up conditional formatting to turn the cell red and even have a formula in the helper column that outputs text of "Please use format of (xxx) xxx-xxxx" right next to the phone number column.

  • StephanieR
    StephanieR ✭✭
    Answer ✓

    Hi Andree,

    This form is for pre-registering for Covid-19 vaccination, so we are getting a couple hundred entries a day. I can set-up a work flow, but what would work if I could have Smartsheet email the client directly with a templated/boilerplate message, if the cell did NOT meet the requirements.

    I can create a workflow to send Phone column with less than 10 digits to "Bad Phone" sheet so we can email this group of people.

    As always you have been incredibly helpful!