Conditional Formatting

Dtuck
edited 12/09/19 in Smartsheet Basics

I am using a form to collect contact information for event registration.  We want our guests to register separate email and phone numbers for each member of the household.  Is there a way to create a conditional format that keeps guests from entering the same phone number and email more for more than one person?

 

Thanks,

d

 

Screen Shot 2019-11-16 at 10.51.44 AM.png

Comments

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    Hi D,

    Unfortunately, it's not possible in Smartsheet at the moment to use any conditional formatting or rules for forms, but it's an excellent idea!

    Please submit an Enhancement Request when you have a moment.

    Two possible workarounds.

    1. An automatic update request that sends if there is a duplicate
    2. Third-party form service

    Would that work?

    I hope that helps!

    Have a fantastic weekend!

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

     

    work-boldimage

     

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.