Sheet Name in report filter not working
Hi Smartsheet Community,
I have added a Condition in the filter to exclude sheets with "OLD SS" in sheet name but it is not working. Can anyone please let me know what I have done wrong? Thank you.
Answers
-
Is it possible there is an underscore?
OLD_SS
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Hi Paul,
Thanks for looking into.
I double checked all sheets and there is no underscore. I also tried using just "OLD" or "SS" and neither works.
-
Hi @Carmen W
I hope you're well and safe!
It might be one of the other conditions that don't work, so try deleting the other and only keep Sheet Name one and test again.
Did that work/help?
I hope that helps!
Be safe, and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
That's odd. I use sheet name in the filter quite often. Have you tried creating a new report and rebuilding it completely from scratch?
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
@Paul Newcome Indeed I tried. What is more weird is that I tried other texts in the filter and it works perfectly fine. For example, if i have a sheet named "ABC_OLD SS", I can filter it out by using Sheet name not include "ABC" but not "OLD" or "OLD SS" or "_OLD SS" or even just "SS".
I added "_OLD SS" to about 50 sheets and none of those sheets got filtered out with the "Sheet Name" does not contain "OLD". But another sheet that is named "old template" is filtered out with "OLD". So I am really not sure what the issue is.
@Andrée Starå I also tried this but it still doesn't work.
Thank you both for looking into.
-
Strange!
I'd be happy to take a quick look.
Can you maybe share the sheet(s)/copies of the sheet(s)? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@workbold.com)
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
I wonder if it has to do with the underscore before OLD. Try removing the underscore (or putting a space after it to separate "OLD" from it) from a couple of sheet names and see if that works.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Hi Andrée and Paul,
I checked my report this morning and the "OLD SS" sheets are gone!
So I think it is just some smartsheet glitch.
Thanks again for looking into this.
-
Excellent!
Glad to hear it's working!
You're more than welcome!
✅Please support the Community by marking your post with the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Phew. That's good news. It's always nice to hear it is a glitch and not some goofy mistake on my end. Haha.
EDIT: I wonder... Did you recently change the sheet names to add that last little bit on the end? I wonder if maybe it was just taking the back-end to catch on that the sheet names had been updated. I ran into that once before some time ago.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
@Paul Newcome Yes I changed the sheet names all at once, for about 50 of them. It also occurred to me that it will take time but after 24hours the filter still didn't work then it got me wonder if I did something incorrectly. It is surprising that it took almost 3 days until the filter works though ...
-
@Carmen W Yes. That definitely seems a lot longer than it should have been. I'm glad it is working for you now though!
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 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
- 284 Events
- 33 Webinars
- 7.3K Forum Archives