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
Call Center
My new challenge is building a service dispatch system within Smarthsheet. I have wanted to do this for a very long time. I am attempting to get alot of information into the sheet and would welcome any help. Im looking to make it like an airport type screen. I am trying to get: * Schedule * Ticket # (CSR#) & Details *…
Overlapping in Sights
Hi, Smartsheet friends! I am creating a Sight that will include various metrics for four different states. I have four PNG files with icons of each state shape. What I would like to do is have the data for a particular state appear on top of the image for that state. Is there a way to overlap the two widgets? Thanks!
Counting checkboxes
Hello, I am counting the children of selected check boxes and then seting a ball color with formula bellow: =IF(COUNTIF(CHILDREN(Comp15:Comp17), 0) = 2, "", IF(COUNTIF(CHILDREN(Comp15:Comp17), 0) = 1, "Red", IF(COUNTIF(CHILDREN(Comp15:Comp17), 0) = 0, "Green"))) This works fine but, when I have more than three checkboxes…
Counting of hours
To All, I am trying to build the Smartsheet as a service schedule. One of the may problems i have right now is trying to add up hours that the technician has worked. Im looking to count the number of hours thats been assigned and providing how many hours to date (Just for the week) that has been worked by the employee
Convert date format to mm/dd/yyyy
Is there a setting or a formula to convert the standard yy in smartsheet to yyyy?
Alerts for Created (Date) Column
I can't seem to find a way to set an alert if the Created Date changes. This would essentially only alert me when a user filled out the web-form and not if someone changed the contents of the row. I have an employee that needs to know when a new row is added, but doesn't need add'l updates when other employees massage the…
I'm looking for a way to calculate time of day based on predecessors.
I have a very specific need to a time intensive schedule that requires time of day (TOD) to calculate based on predecessors. Currently I have been manually entering TOD of Start Time and Finish Time in general columns but would prefer these to be formula driven. Has anyone done this?
Gantt colour bar and % complete colour
Does anyone know how to change the % complete colour in a Gantt chart? The colour of the colour bar and the % complete are too close and I would like a bit of contrast. ie blue colour bar and yellow % complete.
Smartsheet Crashing
Smartsheet has started crashing today. I log out and back in but it does not help. Is anyone else experiencing this today? I have never experienced Smartsheet going down except during scheduled downtimes.
Maybe the wrong software?
Just got off the phone with support and was told we could not take our timeline down to hours. We are going to look into our purchase to see if we purchased the right application. Otherwise how do you make a schedule work?
