Portfolio Metrics

Nicole_Codi17
Nicole_Codi17 ✭✭✭
edited 02/27/24 in Formulas and Functions

I am trying to get a count of all my projects in my project intake sheet. I am using the formula below to reference my intake sheet but it is returning 0 when I have 12. What am I missing?

=COUNTIF({2024 PROJECT INTAKE PROJECT ID}, <>"PROJECT ID")

Thanks in advance

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!