-
Can Viewers hide or filter columns that don't pertain to them?
My team has a spreadsheet that is shared internally (editing access) and externally (viewing access only). For the external partners that use the sheet with viewing access only, is there a way for them to hide or filter to the columns that pertain to them? They need to see all of the rows, but not all of the columns.…
-
Conditional Weighted Averages
Hello, I want to use the AVGW function to get the weighted average of the column "Cost" against the column "Probability of Cost" but only if the column "Status" is Approved. The column "Status" can also be Pending. The function SUMIFS works great if you don't need to do the weighted average. Is there a preset function or…
-
Summing up everyday new entry value into a different smart sheet
Hi, Can anyone give me some idea on Summing up across multiple smart sheets new entry value in separate smart sheet please. I can sum up specific cell values or range but i am looking for sum of daily entered values of same column from different sheets.
-
Access of a Report via Dashboard
Background: I have created a form to capture Company personnel’s proposed ideas to improve cost savings, quality and safety. With this I have also created a Dashboard to give a snapshot of the progress of all Idea’s submitted. On the dashboard I created a button that I had intended for a person without a Smartsheet sign on…
-
Project Team Resource Allocation
Hi, Can anyone share how they're tracking their teams resources? The resource allocation is great however, it only allows me to show one team member not multiple per task. In addition, I'd need this information for executive reporting to support my teams concerns of being over allocated across projects. Thanks!
-
Report on "Current User" on a Sight
When we show a report that is built with the new "Current User" contact functionality, that works great! When we show that report on a Sight, it doesn't dynamically follow whoever is viewing that Sight. The report only shows the tasks assigned to the author of the Sight. That doesn't seem right to me. Does anyone else have…
-
Hybrid Report/Sheet
I'd like to use Smartsheet to track performance on a multitude of projects. I can use a Report to quickly gather a list of assignments and compare Need Date to Date Completed. But I can't add any additional columns (i.e. with formulas to display graphics based on whether the assignment was completed on time) or additional…
-
Report not showing a row
I have a project plan with rows linked to a sheet. I am attempting to pull a report on this sheet, but the report is not pulling in all of the criteria. The project plan has a column titled "Tags", which has Milestone and Timeline. These tags are included on the linked cells in the other sheet. I Run the report to include…
-
Custom Column View Templates
Is it possible to save custom views for columns? I would like to be able to show, hide, sort, and order columns via a template. I am able to filter based on specific conditions but I also need to be able to view the data a specific way.
-
Report assigning random background color
I have a report that pulls in data and then, for some reason, applies a yellow background color that is not found in the original sheets. I found a 2016 discussion with a similar problem. The Smartsheet rep said it could be old data, so they refreshed the db? Is that the same case here? Thanks in advance BK