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.
I want to utilise an IF THEN function in Smart sheet
Comments

There are two ways you could do this! One is using nested IFstatements (https://www.smartsheet.com/blog/supporttipbuildnestedIF), the other way is to use the new LOOKUP functionality. LOOKUP is probably cleaner in the end, but it's less intuitive to use.
1) Using NestedIF Statements your formula would look something like this:
=IF(Job1="Welder", 80, IF(Job1="Crane Operator", 100, IF(Job1="Foreman", 120, ....)))
Basically, if the IFstatement is true you use the number, otherwise you move on to the next IFstatement.
2) Using a LOOKUP table, your smartsheet would look something like this:
The first two columns makeup what is known as a lookup table. These are basically constant, neverchanging values you might want to reference somewhere else in your sheet. Now, in my column called "Text 2" you can calculate the value of whatever is provided in "Text 1" using the LOOKUP formula:
=LOOKUP([Text 1]1, $Position$1:$Number$4, 2, false)
The first parameter here is the value you're looking up, the second paramter is the range of cells that makeup your Lookup Table, the third parameter is the number of the coulmn you want to return, and the final parameter tells Smartsheet if your table is in alphabetical order or not. The dollar signs are used to prevent the formula from automatically incrementing when you copy and paste it into new columns.
I think either of those should solve your issue! Let me know if you need more help, or if I didn't understand your scenario correctly!

Good job Greg on thinking beyond the wording of the original question.
Always good to be reminded of the new features  and how they can simplify things if implemented well.
Craig