Conditional Statements

I am trying to create a formula that would reference two different columns to return an answer. For example,

IF Column D with number is greater than 30 AND if column B is blank = At risk-stale


IF Column B is blank = At risk


  • ker9
    ker9 ✭✭✭✭✭✭

    Hi @ossalcido

    See if this works for you.

    =IF(AND([Column D]@row > 30, [Column B]@row = ""), "At Risk-Stale", IF([Column B]@row = "", "At Risk", "OK"))

    The "OK" at the end is what happens if none of the criteria are met (column B is not blank).

    Hope this helps!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!