Is there a maxium number of characters for the gantt bar label?

Options
Roland Horwood
Roland Horwood ✭✭✭✭✭
edited 11/16/23 in Formulas and Functions

Hi anyone,

I have a custom Gannt bar label set using the gantt timescale settings from a helper column that concatenates some information about that task. This can get quite long, especially if the project name is long, and I'm finding some labels cut off. Is there a maximum length (it seems to be 73?) or am I missing something?

See attached screengrab with missing data.

Any help appreciated - Roland


Tags:

Answers

  • Genevieve P.
    Genevieve P. Employee Admin
    Options

    Hi @Roland Horwood

    It's actually not a character count but an amount of space next to the bar. In my sheets I can get up to 78 with specific text, but if I use smaller characters (e.g. 1 instead of 3) then I can fit more into the title next to the bar.

    For example:

    If all I write is 3's, I can get in 62 3's.

    If all I write is 1's, I can fit more: 85


    Please submit your feature request to the Product team by creating an Idea Post in the Smartsheet Product Feedback and Ideas topic here in the Community. This will allow other users to vote on your enhancement idea!

    Cheers,

    Genevieve

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!