=IF formula question



I wanted to use a formula to input a Pass or Fail dependent on if one of the columns to the left of the score showed a f. If any of those columns show an f it would need to read Fail. Help?

Best Answer

  • Genevieve P.
    Genevieve P. Employee
    Answer ✓

    Hi @Katherine Camacho

    Instead of highlighting the entire column, you'll want your range to go from the very far left cell in this row to the closest right cell in this row. So, this would be your range:

    [Medical Necessity]@row:[Collection Plan]@row

    I would also use a COUNTIF Function to COUNT the number of cells that say either "F" or "Fail" depending on how you'll set this up. Then if the COUNT is greater than 0, return "Fail".

    Try something like this:

    =IF(COUNTIF([Medical Necessity]@row:[Collection Plan]@row, "Fail") > 0, "Fail", "Pass")



    Join us at Smartsheet ENGAGE 2024 🎉
    October 8 - 10, Seattle, WA | Register now


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!