Data Validation in Smartsheet

anilkrag1984

Hi Team can anyone suggest me if there is a way where, If we enter ID 123 in customer ID Field the values belonging to that ID only visible in the other field say in Smartnet Contract Number Field in the Form option. Like Data Validation in Excel. The Smartnet Contract number field should not show values of ID 234.

Smartnet Contract Number Field.png

Customer ID Field.png

Andrée Starå

Hi @anilkrag77641

I've replied to your other post, but included the same answer here as well.

Yes, it’s possible through the Form Logic feature, but you need to create a so-called helper column for each ID, so I don’t think it will work for you.

More info: 

https://help.smartsheet.com/articles/2481701-use-conditional-logic-to-streamline-form-submissions

Another option could be a 3rd-party solution/integration. Is that an option?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!