Why is this formula not working?
Why is this formula not working? For the life of me works in excel.
=COUNTIFS({Network Security Projects Range 1}, [NetSec Group]2, {Network Security Projects Range 6,"Arlyssa Jaquez"})
Answers
-
Hi @David Rice ,
Try this:
=COUNTIFS({Network Security Projects Range 1}, [NetSec Group]2, {Network Security Projects Range 6} ,"Arlyssa Jaquez")
There was a } out of place. Beyond that confirm that when you click on the formula [NetSec Group]2 highlights. If you still get an error we'll go to the next step.
Good luck,
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 419 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 143 Just for fun
- 59 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 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!