-
Help with creating a dashboard
I'm new to smartsheets. I've set up a work tracking sheet with a number of status conditions. I'd like to create a view for folks to use - maybe a dashboard? Let them check the status of their requests, show a pie chart representing the total number of requests in each status, average time to completion, etc. Any ideas…
-
Creating a Temple for Router Configrations
I have an existing sheet with a lot of information in it. I would like to create a template to populate based of the information in my existing sheet. Then I would like to be able to print or export the information to create a router or switch configuration template. Sounds easy enough but have never done this and would to…
-
% complete based on count of child checkboxes.
I'm hoping someone can help me. I have a sheet set as a grid with a list of tasks for designers to do, these are divided into 4 categories, with the tasks being indented beneath the parent category, I have a column called 'complete' that is checkboxes which the designer check once each task is compete, so like a regular…
-
Company uses smart sheet in metro manila philippines
Hi is there any company here uses smartsheet in philippines specially in metro manila? may i know the company name thank you
-
#circular reference error
I'm trying to use a formula to set a symbol column's (RYG Balls) cell color value based on a date cell, however, if the cell color has been manually set to Green I don't want the formula to do anything. For example, the cell in the formula below will default to Yellow. If it has been set to Green by the user, I want the…
-
Cell Linking Max Count
So when I try linking a cell I got the following error "Your sheet has 5000 inbound links" I understand that this is the maximum number of links but, what is considered an inbound link? For instance, I know that the linkInFromCell Objects can have a status like "OK", "BROKEN", "NOT_SHARED", "INACCESSIBLE", and some other…
-
Add field to timeline
Hi, when using a gantt the timeline normally expands between the columns "Start" and "Finish". Now, I have a third and fourth column which I would want to be on the same time line, but not as one long marking. The time period between "Start" and "Finish" should be marked, but then it should be a space until the third date,…
-
Automating RGB Balls from value scale
Hello, I am trying to automate into a status column a stop light symbol that reflects a value in another column that is on a scale - I am not sure what I am doing wrong... =IF([Health Score]12>= 0, [Health Score]12 < =1.5), [Status]12, "Red", IF([Health Score]12 >1.5, [Health Score]12 <=2.9),[Status]12, "Yellow",…
-
IT Help Desk Reporting
Has anyone created an IT Help Desk in Smartsheet? If so, what kind of reporting are you doing against your data?
-
using OR in a formula
Hello Smartsheet Community, I'm looking for some help in utilizing the OR statement within a function which references columns in another sheet. I am trying to count how many rows have a request status of either "Open", "Awaiting Addl Info", or "In Progress" from specific departments who submit these requests. I seem to be…