Help with CONTAINS Returning Invalid Data Type
I have the below formula to count if the department contains Facility and the dates are between January 1, 2022 and January 31, 2022. I am receiving the invalid data error. I have validated the Loss Date column is set for dates and the Dept column is set to text/number.
=COUNTIFS(CONTAINS({Dept}, "Facility"), {Loss Date}, >=DATE(2022, 1, 1), {Loss Date}, <DATE(2022, 1, 31))
Regards,
Ron
Best Answer
-
Hi Ronald Anderson
I hope you are doing well,
I have modified the formula, you can try this formula
=COUNTIFS({Dept}, CONTAINS("Facility", @cell), {Loss Date}, >=DATE(2022, 1, 1), {Loss Date}, <DATE(2022, 1, 31))
I hope it works for you!
Thank you
Thanks,
Kaveri Vipat
Senior Associate - Smartsheet Development, Ignatiuz Software
2023 Core Product Certified
Did this answer help you? Show some love by marking this answer as "Insightful💡" or "Awesome❤️" and "Vote Up⬆️"
Answers
-
Hi Ronald Anderson
I hope you are doing well,
I have modified the formula, you can try this formula
=COUNTIFS({Dept}, CONTAINS("Facility", @cell), {Loss Date}, >=DATE(2022, 1, 1), {Loss Date}, <DATE(2022, 1, 31))
I hope it works for you!
Thank you
Thanks,
Kaveri Vipat
Senior Associate - Smartsheet Development, Ignatiuz Software
2023 Core Product Certified
Did this answer help you? Show some love by marking this answer as "Insightful💡" or "Awesome❤️" and "Vote Up⬆️"
-
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.3K Get Help
- 446 Global Discussions
- 144 Industry Talk
- 477 Announcements
- 5K Ideas & Feature Requests
- 85 Brandfolder
- 151 Just for fun
- 72 Community Job Board
- 489 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 302 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!