Formula Question

Need to create a formula that counts all rows containing the phrase "On Site"

Best Answer

  • Amit Wadhwani
    Amit Wadhwani ✭✭✭✭✭✭
    Answer ✓

    Hi @Graham Cracker

    Assuming that your column name is "Work", use the formula below in a summary field. You need to replace Work:Work with your column name for this to work.

    =COUNTIF(Work:Work, "On Site")
    


    Best Regards
    Amit Wadhwani
    , Smartsheet Community Champion
    Smartsheet CoE, Ignatiuz, Inc., Exton, PA

    Did this answer help you? Show some love by marking this answer as "Insightful
    💡" or "Awesome ❤️" and "Vote Up ⬆️"https://www.linkedin.com/in/amitinddr/

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!