-
Date and/or time stamp solution
We use Smartsheet in many wonderful ways but, in my opinion, the lack of a method to easily lock a cell with a date and/or time stamp is an open door for a competitors raid. A few years ago, I left Smartsheet because images could not be exported with line item details and there was no "key" to associate with a file export.…
-
Remove Mouse hover over pop up tool tips on menu bar ribbon
Is there an option to remove the pop-up mouse hover tool tips on the top menu bar ribbon? It is getting in the way of the feature buttons and has become very annoying. Thank you!
-
Legend Totals
On the dashboard when I add a chart I would like the ability to include a total next to the legend item. For example, if I am doing a pie chart, in addition to seeing the total items represented by that color in the pie chart, I would also like to see the total items next to that heading in the legend itself for quick…
-
Dynamic Status
A more refined and slightly more universal solution to the first posting is as follows: =IF([% Complete]18 = 0, "NOT STARTED", IF(AND([% Complete]18 > 0, [% Complete]18 < 1), " IN PROGRESS", IF([% Complete]18 = 1, "COMPLETE", IF([% Complete]18 > 1, "INVALID ENTRY", IF([% Complete]18 < 0, "INVALID ENTRY"))))) This assumes…
-
Stacked Bar Graph
Is there a way to create a stacked bar graph with the new charts? Thanks! Chase
-
Using COUNTIFs with FIND & AND
Hi, I need to add up the following: 1) All Labeled as Country X from a Qualitative field that is requiring me to use the FIND function. 2) All labeled as AreaY across 3 columns (I have tried selecting all columns as a range and also just selecting the relevant rows as well). Currently using: =COUNTIFS({Consultant…
-
Report Viewability
So I have created several Reports and have noticed that when you add them to a Dashboard, anyone with Dashboard Access can view them as a Widget; however, When made a viewer on the Report itself, all the people see is a blank page. Do the Viewers also need access to the sheet the report is pulled from? If so then reports…
-
Smartsheet for Insurance Solutions
Good Afternoon, I wanted to check to see if there are any users in the Property & Casualty Insurance Industry and if so, could you share what you are using it for? I am a new user and still learning all its capabilities. I see that there is a large Healthcare following but not sure about the P&C world.
-
Duplicates
How do i create a formula that shows there are duplicates. I would like it to have a check box in a column showing that "Sarah Jensen" has duplicate expense submission based off Consultant Name, Date of Receipt,Total Expense.
-
Highlighting Individual Cells Based On Date
I am trying to figure out how to highlight a cell based on how the status of the "actual" column is in accordance with the "Baseline" column. Is there a formula or conditional formatting rule to implement that will automatically change the color of the cell to green or red to illustrate that it is ahead or behind schedule?
