can smartsheet support "comments" and “cell merge”?

Options
aaron.chen97186
edited 12/09/19 in Smartsheet Basics

Hello,

I am wondering whether smartsheet can support "comments" and “cell merge”?

-Cell comments: Write a comments for the value in the cell, like excel?

- Cell merge: merge the adjacent cells as one cell

- Two level columns headers: Ex:

Level 1: Jan

Level 2: Qty, Amount, Price

Now I can only write header as: Jan qty, Jan amount, Jan price, Feb Qty. Feb Amount, Feb price.

 

Any workaround solution is welcome. Kindly help.

Comments

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭
    Options

    Hi Aaron,

    Unfortunately, it's not possible to do any of those things in Smartsheet like in Excel at the moment, but they are all great ideas!

    Please submit an Enhancement Request when you have a moment.

    Workarounds that might work for:

    -Cell comments: Write a comments for the value in the cell, like excel?

    • Use the comment row feature and write which cell it's for
    • Add a column beside the one you'd want to comment on and then you could hide it so it only would be visible in the edit view.

    - Cell merge: merge the adjacent cells as one cell

    • Use colors to make it look like one cell and the JOIN function if you'd want to add information from more cells together.

    - Two level columns headers: Ex:

    • Use the rows in the sheet to add the headers and levels.

    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.