Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums.
Discussion List
Indenting
<![endif]-->I am trying to format cells in a budget and I would like to indent the text below certain categories. For instance, in defining cabinets I have to identify the room, eg Kitchen, and then the various cabinets in the kitchen. I understand the parent/child relationship and how this works, however it doesn’t apply…
Smartsheet Navigation
I have always found navigating between sheets a bit cumbersome. I have several workspaces and lots of sheets. Currently the fastest way to find a sheet is to do a search. The favourites is a neat idea but I usually gave to navigate out of my current sheet to the home tab and then again to the favourites tab. What would be…
getting users to fill in inspection report without disturbing my original template
I have created a survey form (containing 300 items to be checked) which i want to share with multiple users to use when they visit on-site. How do I get them to fill their survey forms without giving them admin rights. The survey form is a fill-in type of check list which grades the site, so the user should be able to…
Not possible to color Gantt bars by what parent task they are under?
I'm setting up a project with big task parents for the major parts of the project with many sub-tasks. Is it not possible to use a conditional formatting rule to make all the tasks under a particular parent a specific color?? This seems like a very basic feature but I can't figure out a way to do it.
Is there a way to round up in 15 minute increments in Smartsheet?
Is there a way to round up in 15 minute increments in Smartsheet? What's the formula for it if I can? I know there is a roundup formula but that doesn't allow you to round up in 15 min increments.
RYG Balls Default to Yellow if Due Date is Blank
Hello! I have the RYG balls working great in conjunction with a "Complete" check mark and "Due Date" ranges. However, I cannot seem to figure out how to apply the forumla to the entire column without seeing a bunch of default yellow balls if the row does not have a due date entered. Is there a way to hide the balls all…
Global formatting buggy?
global formatting works intermittantly for me ... Specifically horizontal cell alignment, text wrap, black font and currency formatting... Anyone having this issue? Thanks!
Payroll
I am trying to set up a sheet that tracks employee hours for the week and any overtime or stop out allowance, has anyone found the best way to do this? Ideally I'd like to use a web form so each employee can pick up the web form, enter their information and it be transferred to a sheet for payroll. Many thanks
Sharing
Can I share a sheet within a workspace without sharing all the other sheets in the workspace? If so, how?
Create Task Start and Finish Dates with Mouse in Gantt?
Is there a way to create start and finish dates in the Gantt chart view by simply clicking/dragging on the Gantt chart calendar? It seems the only way to initially create a start/finish date is by using the Start column and clicking on a date on the calendar that appears. This is clunky and it would be much easier to just…
