Trying to use a formula in the summary sheet with an AND to look at values from two columns
Hello,
I've searched and was not able to find this exactly, and looking over the formula guides I still am not sure how to do this. I am trying to set up a summary field in the sheet summary that looks at the values of two columns and validates both are present to count the field.
Here is the best I could do to try to get it, but it tells me it is unparseable:
=COUNTIF(AND((Risk:Risk, "Not Scheduled"), ([Client Facing]:[Client Facing], ISBOOLEAN(Done1))))
I am trying to look at the values of a single dropdown column RISK and the checkbox column CLIENT FACING and only count the value for each row if:
- value in RISK column = "Not Scheduled"
- CLIENT FACING is a checked checkbox
From what I can tell, the COUNTIF is still looking for the criterion, but since it is an AND statement, the criterion is within the AND grouping.
Where am I going wrong with this?
Thanks for any help.
Best Answer
-
Try this...
=COUNTIFS(Risk:Risk, "Not Scheduled", [Client Facing]:[Client Facing], 1)
Answers
-
Try this...
=COUNTIFS(Risk:Risk, "Not Scheduled", [Client Facing]:[Client Facing], 1)
-
Worked like a charm. Thank you very much!
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.1K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!