formula help

Deanna Vandermeer
Overachievers Alumni
I need to write a formula to count the number of projects in a sheet but subtract all projects that are tagged (checkbox column type) if the cyclical column is checked. Does anyone have any suggestions or help they can share?
Smartsheet Overachievers Alumni
Tags:
Best Answer
-
You could try something like this...
=COUNTIFS([Project Column]:[Project Column], ISTEXT(@cell), [Cyclical Column]:[Cyclical Column]:[Cyclical Column], <> 1)
Answers
-
You could try something like this...
=COUNTIFS([Project Column]:[Project Column], ISTEXT(@cell), [Cyclical Column]:[Cyclical Column]:[Cyclical Column], <> 1)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.2K Get Help
- 430 Global Discussions
- 150 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 500 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!