-
Number Color Conditional Formatting on Dashboards
I would like conditional formatting by color on "number" displays on dashboards.
-
Harvey Ball status based on due date
Greetings Hope everyone is doing well. I have a need for some guidance. I've used a similar formula in the past but I am having issues with this one. What am I trying to do: I have a status column and RTDD date column and Symbol column for the Harvey Balls (red, yellow, green, and gray) I'm looking to have the balls color…
-
Show all files that are pulling information from a file
We want the ability to see (on any file type) what other files are pulling information from the current file we are on to understand the dependency between sheets/dashboards/reports/etc.
-
Target range in graphs
I would like to be able to have a highlighted/shaded section on a graph indicating the target range desired for the data being displayed in the graph. For example, The graph is depicting the average number of patient's seen per therapist per shift… the target range is 6-8…. is it possible to have a shaded line parallel to…
-
Gantt Timescale Settings in Smartsheet Gov
It would be great to expand the Gantt view timescale settings to see just one quarter at a time within SmartsheetGov.
-
Linking Smart sheet columns to a Resource Management Project Cutoms Fields
I would like the ability to automatically update values in Resource Management custom fields from values in a Smartsheet sheet either a column or in a Summary field. Examples of how this could be used:. In smartsheet I have a portfolio Priority calculation sheet. I would like the priority calculated in the priority column…
-
Added 2 years to date, only want to populate in specific fields
I have created a calculation to add 2 years to a specific date listed in a field, but I would like to create a formula where it calculates the 2 year date but only populates if the other field is filled in. Current formula: =DATE(YEAR([PO Date]@row ) + 2, MONTH([PO Date]@row ), DAY([PO Date]@row )) If the PO date is fill…
-
Hyperlink Color on Dark Background
Hi, I'm new to SmartSheet so I may have missed something. When I add an hyperlink on a cell with dark background, is there a way to make the text white or any other color that would allow to read it? I thought the automatic mode would change the color, but it does not let me do so... any ideas? Do I have to stick with…
-
Level Up Your Smartsheet Skills With Upcoming 10xViz Events
Hello All, I hope your year has been off to a great start! Looking to strengthen your Smartsheet skills and get direct access to experts? Our team at 10xViz has several upcoming opportunities to help you work more efficiently and confidently in Smartsheet, both in-person and virtually. If you need to get a solution…
-
Fx decimal place output is too much
How do I correct the formula below to show only 2 decimal places? =IF([Total (Current) Annual Cost $]@row - [Total (Proposed) Annual Cost $]@row < 0, "(", "") + "$" + ABS([Total (Current) Annual Cost $]@row - [Total (Proposed) Annual Cost $]@row ) + IF([Total (Current) Annual Cost $]@row - [Total (Proposed) Annual Cost…