IF formula to Assigned To

I am having trouble trying to figure out the formula based on the example:

If the ISSUE TYPE is PTO, then assign it to XXXX.

I have one column labeled "Issue Type" with a dropdown selection, and the other column labeled "Assigned To".

Please help!

Answers

  • Mark Cronk
    Mark Cronk ✭✭✭✭✭✭

    Hi @Regina Botell ,

    How many issue types and assigned to options do you have and how often do they change? If it's only a few you can hard code it into a formula. If it's more than 3 or 4, or they change frequently, you're better off creating an assignment table and using a vlookup to determine assignment. Making changes in the assignment table is usually easier than changing the formula code.

    A formula would be a series of nested IF statements in the Assigned To column: =IF([ISSUE TYPE]="PTO", "STEVE", IF([ISSUE TYPE]="YYYY", ""MARY", IF([ISSUE TYPE]="ZZZZ", "REGINA", "UNASSIGNED")))

    If you need to create a look up table I'm happy to help there too. The formula in your Assigned to cell would be something like =VLOOKUP([ISSUE TYPE]@row, {..table reference}, X)

    Help?

    Mark


    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!