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
- Smartsheet Customer Resources
- 64.2K Get Help
- 419 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 142 Just for fun
- 58 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 299 Events
- 38 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!
