-
VLookup with IF statement
I am going to try the out of spec condition using VLookup. I am not sure this is possible. But here we go. This log has entries that will VARY but do have upper and lower limit specs. However, in the same stage one substrate may have a different u/l spec sujch as seen here with CRS UPPER limit of 175 and all others have…
-
Capturing a Total Count to display in a Dashboard
I am trying to capture the total number of active projects found in a specific Workspace. Each project is its own, separate, SmartSheet. The way I am able to do this now is by manually creating a Formula (COUNTIF({Proj Name Range 1}, "Yes"),in a separate SmartSheet, and then creating a Metric Widget within the Dashboard to…
-
Managing and Reporting on Multiple Projects Effectively
I apologize for the length of my post, but I want to be thorough in describing what I would like to do and what I’ve already tried. I’ve also searched through help and the forums, and I either haven’t found a solution or am too hyperfocused on what I’m trying to do that I’ve missed it. I’m looking for a way to manage and…
-
Colors for chart widget not preserving settings
Hi all! I am fairly new to Smartsheet but have been taking training where I can to get up to speed. I'm stuck on one particular issue and I'm hoping someone can help. I set up a couple of donut chart widgets to track task status for a couple of sub-projects. These charts get data from a metrics sheet I set up. The idea is…
-
Locking in Colors for Charts in Dashboards (Avoiding category colors changing with dynamic data)
Hi, I am having an issue with Pie charts changing colors when data in the underlying sheets is altered. For example. If I have a pie chart with categories for task status: Not Started, In Progress, and Completed. Lets say I designate those colors Red, Yellow, and Green in the Pie Chart. If the underlying data changes so…
-
How do I avoid an export to Excel combining multiple cell values into one?
I have a sheet that contains cells that are populated from a multi-select drop-down. Many of those cells contain two or three separate values. When I export the sheet data to Excel, those multiple values get combined into a single value. For example: A cell in the sheet contains three category values: Content labeling,…
-
Sheet Summary Report Grand total row ?
I am bringing in 2 separate sheets into a sheet summary report using a custom column called "Total Revenue" which is a sum of each individual sheet's revenue rows The sheet summary report is showing correctly both rows for each sheet and the corresponding totals for each sheet. e.g. Miami $138,875 Tampa $264 My question is…
-
How to Change Background Color on Forms
Hello Community, How do you change the background color on submitted forms? The color is either green or yellow and the rows do not respond to background color changes or font color changes. Sometimes forms get submitted and then cancelled so I want to highlight the cancelled form rows red. Why can't the admin of a form…
-
"Save As New" Not Preserving Cross-References
Hello, I'm building a sheet in which I'm using lots of cross-references in the sheet summary. I plan to use it as an active metric field to display summary information from data in other sheets. I will need to copy the sheet about 30 times. I want to do this without breaking the cross-reference since it would be VERY time…
-
Protecting Folders From Admins In Workspace
I have template folders in a Workspace that either gets edited or deleted by Admins. I cant make them editors because then they cannot make folders and edit other documents that they need to work with. Is there a way to make it so certain folders can be protected? Thanks!
