Formulas and Functions

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

Return value from specific columns based on input

I am looking for help with a formula. Based on the input in one cell (Column A), I'd like to return the value from one of six other cells in the same row (Columns B-G) based on the specific input in Column A. I am getting stuck on how to set this up. Column A will always have the same 6 potential inputs that would lead to a different cell being returned in my equation column.

Thanks in advance for your help.

Don

Answers

  • I may have brute forced fixed it with multiple if statements that point to different columns.

    =IF([Next Phase]@row = "Lead Generation", [Proj LG]@row, IF([Next Phase]@row = "Lead Optimization", [Proj LO]@row))

    I'd be happy to hear if there is a more elegant way to do this.

    Thanks,

    Don

  • ✭✭✭✭✭✭

    Hi @Don Wyma

    Hope you are fine, you can do that by creating a table of your inputs and use Vlookup or Index with Match functions to do that and select the input automaticly.

    PMP Certified

    bassam.khalil2009@gmail.com

    ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions