Auto fill Dept column based on selection in Category column

Stacy Maplesden
edited 01/07/21 in Formulas and Functions

Hi - I'm very new to smartsheet and formulas so I apologize if this is a really basic question. I have been researching how to have my DEPT column autofill the correct department depending on what is filled in the Category column but not having any success. The Category is selected by the end user that is reporting an issue on a form (drop down field). This category column is automatically filled on the sheet when the form is submitted. I'd like the Dept column to fill in the appropriate department that matches the category when submitted. This is the sheet that the form feeds into:

This is my list of categories and associated departments which is on a different sheet, as a reference.


Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!