Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Populate Row based on a pulldown selection.


I maybe shooting for the moon on this. 


I am building a meal planning tool. I have a sheet that has the name of the recipe and then several columns that are the ingredients of those recipeies. in the ingredance columns i have placed a number that represents how many of that ingredant is needed.


I have a second sheet that lists each meal of the day and each day of the week. I have a column with a dropdown list of all the recipe names. What i would like to be able to do is have the amounts in the ingredance columns to autopopulate based based on the recipe name selected. In Excel i would use a lookup tool and have it referance the recipe sheet and then report back the amounts in the ingrdance columns.


I am not seeing an way to do this in Smartsheet. Am I missing something?





  • JamesR
    JamesR ✭✭✭✭✭✭

    No you are not missing something, Smartsheet does not have lookup functions. You might be able to achieve this by having only 1 sheet rather than 2.  Split the sheet I to two. Top part as your daily planner ant the bottom part as the data part.  Using the if functions (if, sumif, countif) you may be able to construct something.

This discussion has been closed.