-
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…
-
Make sheet data available to external 'viewers' but limited to only their data
Good morning Smartsheet community. I have been using Smartsheet in my job as the office manager for a small business. I'm self taught and have managed to get some workflow and automations working through trial and error. However, I am stumped on the next project that I'm trying to figure out how to best handle inside…
-
Why can’t I suddenly not edit any sheets in a shared workspace where we both are on a pro plan ?
I am unable to edit several sheets where I am either the owner or have Admin permissions. Both the sheet owner and I are on a Pro Plan, and I have confirmed that I am a licensed user. I have also verified my Admin permissions, checked for locked content, and ensured my browser and app are up to date. Despite these steps,…
-
JOIN/COLLECT - Order by most recent
I’ve configured a Smartsheet process—fed by Data Shuttle—that supports multiple activity rows per consumer. Each row calculates a unique Row ID and helper flags (Occurrences, Duplicate Entry, Duplicate IDs) and builds a Detail Key that concatenates Item, Supply Count, Date, and Person. Using these helpers, the sheet joins…