-
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…
-
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?
-
Bug: Comparing max(system date) to system date returns incorrect result
I'm trying to retrieve the latest created date and compare it to the date-time. I was expecting to get a date, not a date-time, and that would be OK. =MAX(Created:Created) returns 11/29/16, which is what I expected. However, comparing the [Created] column to this value returns some rows that were created on 11/28: I've…
-
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!
-
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.
-
ColdFusion and SmartSheet API
0down votefavorite I'm attempting to call the smartsheet.com api and read the JSON data from a list sheet request. Im new to API's so I'm certain I'm missing much with my code. Here is what I have so far: <span class="tag" style="border: 0px; color: #7d2727;"><cfscript></span><span class="pln" style="border: 0px; color:…
-
nested forumlas
Hello, I'm having trouble with my nested formula and activating the Red, Green, Gray, Yellow ball based on the % compelte column. =IF([% Complete] = IS BLANK, activate the RED ball =IF([% Complete] = less than 100%, activate the YELLOW ball =IF([% Complete] = 100% activate the GREEN ball =IF([% Complete] = 0% activate the…
-
Engineer's timesheet
Has anyone created a timesheet for tracking/recording billable hours towards specific projects.
-
Update Request Enhancement Wish List
Hello! I have been researching how to use update requests to send automatic messages to different users within a database concept I am developing; however, I have run into a few gaps, so here is my update request wish list! :) 1. Send recurring update requests based on a date column. 2. Add additional criteria options…
-
Sight GANTT Issue
I have a report section in a sight including a GANTT chart. The report itself displays the GANNT starting at the first task start date or today with the GANTT paramter. When viewing the sight, the GANNT always seems to start in January. This particular project starts towards end of year so I have 10 months of empty space…
