Display text in a countif formula
I have a project type column and I want to show in the summary row at the top of my sheet the number of PoCs and Pilots.
Instead of just displaying the number, I want the cell to read PoCs = 22 or Pilots = 15
=(COUNTIF([Project Type]3:[Project Type]69, ="PoC"))
Tags:
Best Answer

To add text, you would wrap it in quotes and the "add" the formula.
="PoCs = " + COUNTIF([Project Type]3:[Project Type]69, ="PoC")
Answers

To add text, you would wrap it in quotes and the "add" the formula.
="PoCs = " + COUNTIF([Project Type]3:[Project Type]69, ="PoC")

thanks @Paul Newcome !! I was using a comma instead of +
You're a lifesaver ⭐️

Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!