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
- 65.1K Get Help
- 444 Global Discussions
- 140 Industry Talk
- 472 Announcements
- 5K Ideas & Feature Requests
- 83 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 35 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!
