-
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)…
-
Assigning multiple resource to a single task
Proposed solution: to create "dummy" tasks in case multiple resource are assigned to a single tasks, sounds very amateurish for a great professional product like Smartsheet. Are there any plans to add ability to assign multiple resources to a single tasls like MS Project?
-
Send notifications to multiple users for single task
Currently with a task column and then with an 'Assigned To' column with the contact list type, you can only insert one contact for each task. I have several tasks where there are multiple people assigned to that single task. I would like to send out notifications to each user assigned to that task. What is the best way to…
-
Why can we still not assign multiple resources to a task?
How in the world is there still not a way to assign multiple team members to a single task? This is such an essential feature to my company (and I would imagine many others), that not having it available basically makes Smartsheets useless for us. It certainly makes the resource allocation tool useless, and that is really…
-
Charts - Legend adjustments
Hello smartsheet, Is there a way to change the icon size and text size of the legend in the charts? For several of the charts I create require legends, but the legend size is out of scale with the rest of the chart. Thoughts? Cheers, BB
