-
% 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…
-
Dates - Gantt Chart
I'm building out a plan with tasks and dependencies and want the dates to populate based off a vlookup. For example, If "Sprint 12" is selected then the proper start date is set in the Sprint Start Date column...which I am doing now with =VLOOKUP([Sprint Start]4, $[Sprint Start]$123:$[Sprint End Date]$136, 3, false). The…
-
Automatic Daily Task Report
Hello, I wish to have a Automatic Daily Report on Smartsheet but I didn't find a way to do that yet. I manage some resources and they are allocated in many projects at the same time. Many tasks have duration bigger than one day, so basically I need a report to serve as a reminder to them. The logic behind need to be…