Formula Question
Need to create a formula that counts all rows containing the phrase "On Site"
Best Answer
-
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
-
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/ -
Thank-you Amit! That worked!
Help Article Resources
Categories
Check out the Formula Handbook template!
