Excel Form. works well but not in Smartsheet =COUNTIFS(Q:Q,"<>*/*/*",Q:Q,"<>",Q:Q,"<>Complete")"

Best Answer

  • Meredith Krueger
    edited 03/01/21 Answer ✓

    =COUNTIFS(Prep:Prep, FIND("/", @cell) > 1)

    This one worked! After renaming the "Q" to my column name "Prep" it still wouldn't work until I renamed the column to something different, renamed the formula to match and then reverted the column name to the orig (which adjusted automatically in the formula. x

    I appreciate you working with me on this and helping me find a solution! Thank you.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!