Simple count
=COUNTIF({Client Name Spring Data}, [Client Name]@row)
This formula is bringing me the correct answer. However, if the answer is zero, I'd rather the cell remain blank. I tried doing another If formula outside the countif but to no avail. I KNOW there is a simple fix.
Thanks in advance :)
Answers
-
Hi!!
I would think the IF statement in front of it should work - can you share the formula you tried?
This is what I would try!=IF(COUNTIF({Client Name Spring Data}, [Client Name]@row)=0, "" , COUNTIF({Client Name Spring Data}, [Client Name]@row))
-
Hi Kristin,
Thank you.
Yes I tried something similar, but I did not punctuate property.
You fixed it for me!! Much appreciated.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 486 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 74 Community Job Board
- 498 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!