What other options do we have to format the sheet better, perhaps even in sections?
Merging some cells will help get rid of the lines and make things look better spacing wise.
My advice would be try not to format a sheet in the way one would in Excel. With Smartsheet there isn't the level of design tools available as in Excel. I advise my delegates to think of Smartsheet more inline with a database table storage rather than a spreadsheet. You set up columns with datatypes, the data needs to be contiguous in order for formulae and functions to work effectively. (i.e. blank lines break automatic formulae autofill and can cause issues in other functions).
Use Dashboards to present the data from the sheets in a more pictoral way if needs be.
Debbie Sawyer Consultant & Training Manager
Unfortunately, it's not possible at the moment to merge cells, but it's a great idea!
Please submit an Enhancement Request when you have a moment.
There are some tricks. Coloring and hierarchy are two.
Would that work?
Hope that helps!
Have a fantastic day!
Workflow Consultant / CEO @ WORK BOLD
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
This is really sad to know that this request of adding "merging of cells" as a function to smartsheets has been requested time and time again at least since the beginning of 2015.. 5 years and this simple function is still to hard to handle.😪
How can a feature as basic (perhaps not technically) not be implemented by now?
And why can't I upvote an existing feature request? . need to sort this out if you're going to be taken seriously.
I have a report that is filtered by a particular folder within a shared workspace... everytime I remove items from that folder the report no longer watches the folder, and it turns into individual items within the folder... Is this common behavior? Has anyone else experienced this behavior recently? I want the subfolder to…
I need some help translating a formula from Excel into something that I could use with Smartsheet. The final formula in Smartsheet would end up being a nested if: If Enterprise 2022 R1, give # of months between GA date and Go-live date, if EDIS 2022 R1, give # of months between EDGA Date and Go-live Date, if these are…
OK, this might not at all be possible but I am hopeful and am not giving up until I find out it can't be done... Hello Smartsheet Community!! I've been playing around with creating a Report, specifically a Row Report in that case. It works fabulous and YouTube videos are a great help! This "issue", though, I am unable to…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2024. All Rights Reserved Smartsheet Inc.