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.

IF/THEN question

Can you link to a good video giving IF and THEN formula examples

thanks

Best Answer

Answers

  • ✭✭✭✭✭✭

    The if function is pretty straight forward.


    it is set up like this,

    IF what i want is true , Then say this, if not then say this

    for example if I had a column that if it had a value of "Blue" I would want it to say "Go" but if did not say "Blue" I would want it to say "Stop" my formula would look like this

    =IF([Column Name]@row = "Blue","Go","Stop")

    the first thing in the IF statement is you logical statement or what you want to see if it's true or not. the second thing is what to return if it is true. the last thing is what to return if it is false.


    If statements starts around 3:50

  • Im still having trouble, how would you build the formula for this?

    If cell 1 in the severity column is "Minor"

    and cell 1 in the likelihood column is "RARE"

    I need the cell in the level column to automatically turn green and say "LOW"

  • Thank you Very much

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions