why is Primary column not left justified?

Stephanie Kiecker

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?

Brian W

Is it possible they are all indented?

Stephanie Kiecker

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

 

Andrée Starå

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

Paul Newcome

There is also the fact that numbers in SS are automatically right justified.

Mike Wilday

I second Paul's suggestion. Because you are using numbers they will always be right-indented. 

Stephanie Kiecker

Thanks all! Sounds like an issue that can't be fixed 

Andrée Starå

Happy to help!

The best option is to: Please submit an Enhancement Request when you have a moment.

Best,

Andrée

Paul Newcome

Happy to help. 

IPC

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

Genevieve P.

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

Mike Wilday

@IPC did Genevieve's suggestion work?

IPC

Hey it worked! @Genevieve P.

Also, thanks for checking up on my inquiry @Mike Wilday