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β¦