-
Need Help - Can't Wrap my Head Around SS Logic
I'm trying to build a metrics table that can be used to generate a graph on a dashboard. I am a consultant and would like to track client hours from a master sheet that logs all clients, dates of services, and total hours. Let's say I wanted to track the hours of utilization from a particular client from YTD, Last Month,…
-
Filter rows based upon unique value
I created a report that retrieves the Assigned To column field for all of the rows in a project sheet. There are several rows where the same resource name is shown in several rows. How do I filter all of those rows into a list that includes just the unique resource names for all the project rows? Do I need to do some…
-
Report Builder Enhancement Request - filter on sheet name
I would like to run a report on tasks per employee assigned with in a workspace. This is pretty straight forward and easy to accomplish. It becomes difficult to do when the sheet count for a work space goes over 250 sheets. In my workspace, we typically have 15 sheets per clients, and with over 20 clients in a workspace,…
-
Sharing of reports without sharing the underlying data
Is it possible to share a report to a user, without them having access to the underlying sheet(s)? This means they can only see the entries that are relevant to them? I seem to think that the sheet(s) have to be shared as well as the report, but maybe i'm approaching it the wrong way
-
Will we ever be able to assign a task to multiple resources?
Is there any update on when this feature will be implemented? I cannot believe it is still not possible to assign a task to multiple resources. We are going to need to move to another site soon if this issue is not resolved. It seems crazy that after 12 years, this essential feature still does not exist, while something as…
-
Report-level access to sheets
Hi, So, there are plenty of ways to view the data in a sheet, and to regulate access. My issue is when a sheet contains sensitive data, and that you want to give view and update access to only a few of the columns via a report. A good example is a column for internal comments and one for external/customer comments. Since…
-
Lock Column on Report
I would like Smartsheet to add the ability for an owner/admin to lock a column on a report. Use case: We have a very complicated process where multiple departments collaborate on a single row with hundreds of columns. I would like to make a report for each department that contains a mix of columns that they can edit, and…
-
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.
