Plus sign in front of a cell value
We just noticed a plus sign appeared in front of a value in a sheet and when you click on it, it becomes a minus. How did it get there? What does it mean and how do we remove?
Best Answer
-
Hi @Alta
If you don't want to click on the + sign to expand the Child Rows, I would suggest right-clicking on the column name, then selecting Expand All.
Then you can see all the rows indented below your current one!
I would recommend reviewing the Help Articles that @Andrée Starå has linked above as they'll have more information.
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Answers
-
Hi @Alta
I hope you're well and safe!
It sounds like it's the Hierarchy feature. (Parent/Children).
Can you share a screenshot?
I hope that helps!
Be safe, and have a fantastic weekend!
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.
-
What does that mean? How do I get rid of it?
-
You can use these to change the Hierarchy to get rid of it.
More info.
✅Remember! 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.
-
Sorry but that just indented the cell content. It didnt remove the plus/minus sign. Any other suggestions?
-
Did you check the link as well? There's a gif on how to do it.
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 watched the video but it doesnt change anything. No matter what I do that plus/minus stays there.
-
Ensure that you don't have any activated filters and that you've expanded the + signs completely.
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 dont know what you mean by expanded the plus sign. I removed all filters. if I then indent or outdent it creates more pluses and minuses so I just undid that.
-
Hi @Alta
If you don't want to click on the + sign to expand the Child Rows, I would suggest right-clicking on the column name, then selecting Expand All.
Then you can see all the rows indented below your current one!
I would recommend reviewing the Help Articles that @Andrée Starå has linked above as they'll have more information.
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
Okay I think I now got rid of it. Thanks
-
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.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 455 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives