Automation for ever-changing database
![Gieen](https://us.v-cdn.net/6031209/uploads/defaultavatar/nWRMFRX6I99I6.jpg)
The company I'm working for has a database that houses info for our external clients, the database is constantly being updated nearly daily, I want to create visuals on a dashboard for various statistics based off the columns of information.
I used =countif and it worked well for some columns, but I quickly ran into an issue with some columns from the original database were dropdown lists and many cells had multiple criterions, and =countif seemed to be only giving me the statistics for cells that only content the one criterion and none others, meanwhile there were countless other cells that housed that same criterion i was looking for, but because it was grouped with other criterions, it was factored out and now making the data inaccurate. I was wondering how I could get these statistics to display accurately. I appreciate any help
Best Answer
-
The @cell portion simply tells the CONTAINS function to evaluate the previously established range on a cell by cell basis. In your case, this should be left as is.
Answers
-
Not sure what formula you were using but CONTAINS should help with the challenge.
-
Hi, thank you for the suggestion, I think a formula that works for my situation: =COUNTIFS([]:[], CONTAINS("", @cell)), although I am confused by what @cell means, could you help on this?
-
The @cell portion simply tells the CONTAINS function to evaluate the previously established range on a cell by cell basis. In your case, this should be left as is.
-
Thank you so much!
-
Happy to help. 👍️
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives