Drop Down Menus
Comments
-
You would need to create an IF formula. Please note that smartsheets does not use column letters for its formulas but uses column names instead. Replace Column name B in the following formula, with your own column name and you will have a formula for the column and row 3. I nested an additional couple IF statements so you can add other statements and see how it goes.
=IF([Column Name B]3 = "5", "Tom, IF([Column Name B]3= 6, "John", IF(Column Name B]3 = 7, "Oscar")))
Here is more information on IF statements: https://help.smartsheet.com/function/if
0 -
Cross Reference the data from another sheet.
https://help.smartsheet.com/articles/2476606-formulas-reference-data-from-other-sheets?frame=0&nav=1
Use a VLOOKUP to get the appropriate value from a separate Look up table.
0