Primary Column

Options
Khari Shiver
Khari Shiver ✭✭✭✭✭
edited 05/06/21 in Formulas and Functions

Hello everyone,

I am using Smartsheet to manage a product database. The master sheet contains all the relevant data company wide and it automatically passes the information to specific sheets for certain regions based on automation. I created a form that allows me to add a product to the master sheet but I've run into a situation with the primary column.

The columns in the sheets are "Region (Primary)," "Region," "Department," "Item Name," and "Price." As the primary column can only be text, I duplicated the data in the "Region (Primary)" column and created a "Region" drop down list. The form I created that can be used to add a product has both "Region (Primary)" and "Region" listed. The challenge is because the "Region (Primary)" is a text field, people can enter whatever they want to. I would like to find a way to ensure the value in the "Region" field is the same as the "Region (Primary)" field. Is there a way to use logic to copy the value chosen from the dropdown list associated with "Region" to the "Region (Primary)" field?

Thank you for your help.

Tags:

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!