-
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…
-
Feature Request: We need advanced functions to connect and control multiple sheets
I am a project manager at a construction company so we use Smartsheets pretty heavily for everything from vehicle mileage reporting to project forecasting. The single biggest improvement that I would like to be done for Smartsheets is for greater links between multiple sheets. We are thinking about migrating to Sage 100, a…
-
Request: Allow cell references from different sheets
I'm really enjoying the powerful abilities of Smartsheet, and especially the ways in which it's more flexible than Excel. I have to say, though, it's getting more difficult to accept that formulas just can't reference data from other sheets. This is particularly frustrating when you consider the powerful functions that…
-
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…
-
Non working days
Hi, Is there a way to limit Non working days for a Plan to individuals? One of my developers might be out for a few days but I dont want the plan to skip those days for all. Thank you!
-
Multiple approval requests
Hi Smartsheet, Is there any possibility to change approval requests behaviour? I have a quite dynamic sheet where user has to ask for permission to do tasks. These requests are almost perfect, as they going through to his manager with light speed and this is fine. But when manager has to go through those requests he has to…
-
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…
-
How Smartsheet define, handle and monitor allocation on teammember
Hi fellow Smartsheeteers, I encounter another challenging scenario that some of you have encountered and find a solution to it. Here is the scenario: I have task as an individual and also have task as a team member. Example of task that involves team are doc reviews with a group of people. I have numerous scenarios: 1)…