Need support using wildcard & sumif function
Hello, I have a sheet that's I'm trying to use the sumif function in, but I'm trying to base the criteria on a wildcard.
For reference this is a sample sheet I made, and the wild card formula works fine in excel. Essentially, I want to SUM the values in the "RoleValue" column for a specific condition in the Quarter column.. So if the Quarter Column has a Q2-2024 in it, it will sum each corresponding RoleValue cell that matches that (in this case the value would be 3.1. If I query for Q3-2024 the Total value would be 1.8. I can get this to work in excel with the example formula I wrote out in Column5 row2, but I don't know how to do this in smartsheets. I've tried a few combinations of using sumif and contains, but no luck. Any support on solving this would be appreciated. Thank you!
Best Answer
Answers
-
-
This formula does exactly what I was looking for! Thanks so much, Parul.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 377 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 33 Webinars
- 7.3K Forum Archives