-
Timeline view task bar displaying the task name + % completion
Hello there, I wanted to check if someone knows a way to reflect the task name and the % completion on the task bar in the timeline view. For now the best way I found is to go to timeline view>project settings>item title>%completion and therefore showing only the % completion in the task bar. But by doing this, then I…
-
Logarithmic scale for chart widgets
When using Dashboard Chart Widgets, the charts look great if the data is within similar parameters for each row/column. However, if you have one row that has outlier data (see picture), then all the other rows are hard to visually see what's going on. The solution would be to allow for charts to have a logarithmic scale to…
-
Custom Colors for Sheets
While it is wonderful that we now have the ability for custom colors on Dashboards, it would be truly helpful to also have this same ability in Sheets. It would be really helpful for some of our projects because our district uses certain colors to call attention to various district initiatives or our district instructional…
-
Recipients not receiving alerts
This discussion was created from comments split from: Custom Certificate/File.
-
I am trying to count days that an employee works on specific tasks in set periods.
Right now I am tracking an employee's total amount of days working with a specific scope of work. I am using our company master schedule to pull data from, then a support sheet that is set up with each of the employee's names to track. It works smooth except when a project over laps my specific dates ranges. I need to…
-
Update cell via Power Automate
Has anyone been able to update a particular cell using Power Automate? I'm working on a project where we are using Smartsheet to record the completion of certain tasks performed by Power Automate, to meet reporting requirements. Partially completed rows already exist for each task, containing identifiers for each…
-
Combine individual Contact cells by formula
Hi, I have 2 individual columns and they are with property "Contact". I would like to combine the contact values of these 2 columns and store them in the 3rd contact column, that means the 3rd column can store multiple contacts in the cells. Is there be a way to combine two individual contact cells into one cell with both…
-
My risk formula for program row with child Projects progression is not working.
I am tryings to create a risk formula for Program that has list of projects as a child. Following are conditions to mark the project as either Green, Yellow, Red or Blue: Blue: - Project has progress (% Complete > 0) but hasn't officially started yet (Start Date is in the future) - Indicates early progress or a potential…
-
How to show % complete compared days in a year
Hello, I'm new to Smartsheet and I've built a few widgets but I'm currently having trouble with one I'm trying to build. I'm trying to create a widget to show the percent completed of a project compared to the year completed. I have several projects that are needing to be added up to show a % and want to compare that with…
-
Analytical Lab Management
Does anyone use smartsheets for analytical laboratory management? I have just started and am eager to see what others have done. My company gets testing requests for LC-MS targeted analysis, total fluorine analysis, differential scanning calorimetry, etc., and each request comes with a set of samples. I want to streamline…
