why is Primary column not left justified?
No matter what I've tried, my Primary column seems to display with spaces before the first number, like it's more center justified than left justified. I have many columns so I'm always trying to reduce column width whenever possible and my numbers get cut off if I try to do this with my Primary column - it's like the number have 2-3 invisible spaces before them. Any suggestions on how I can fix this since the justify button does not fix the issue?
Comments
-
Is it possible they are all indented?
-
My only option that I can see is to "align left" - I'm not seeing the typical "indent" icon like I would in Excel so not sure how I would check to make sure they are not
-
Hi Stephanie,
The Primary column is always more to the right than the others, and it looks like your column has a parent, so the indent makes it go even more to the right.
Do you have a filter active on the sheet?
Hope that helps!
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
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.
-
There is also the fact that numbers in SS are automatically right justified.
-
I second Paul's suggestion. Because you are using numbers they will always be right-indented.
-
Thanks all! Sounds like an issue that can't be fixed
-
Happy to help!
The best option is to: Please submit an Enhancement Request when you have a moment.
Best,
Andrée
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.
-
-
HI @Paul Newcome ,@Andrée Starå @Mike Wilday
My case is somewhat the same. The sheet is left indented, I did a report taking columns from that sheet and it remains left justified (Figure 1); but when the report is used in the dashboard it became "center justified" (Figure 2).
Figure 1:
Figure 2:
Any advise?
Thanks in advance
-
Hi @IPC
Since Primary Columns only show in Reports and Sheets as left-justified with a bit of a space, this means that if a formatting is applied to it you won't see it in the Report or Sheet.
However! If you had tried to apply "center" formatting to the text previously, even though it's not showing in the sheet it will show up when you use a Report Widget.
Try clicking on the column name in the sheet and apply the Left text formatting. Save the sheet, then check your Dashboard.
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
@IPC did Genevieve's suggestion work?
-
Hey it worked! @Genevieve P.
Also, thanks for checking up on my inquiry @Mike Wilday
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 466 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives