-
How Can I Resolve #INVALID Errors in Automated Capacity/Utilization Report?
Hi Smartsheet Community, I’m running into #INVALID errors in a resource management report and can’t seem to track down the root cause. I’ve attached two visuals for context: A screenshot of the report showing which team members are affected (#INVALID appears across all months for some users like Jerritt and Danny). A data…
-
Smartsheet Backup and Recovery
We would like Smartsheet to provide a mechanism to do a full backup and restore of related files. While a step in the right direction is the ability to restore to a previous version of a sheet, we find that in an integrated environment, this would not be sufficient: We have a single worksheet that drives multiple reports…
-
We are unable to Delete smart sheet account
Hi, we are unable to delete smart sheet account there is no option when we login into any users account and also when we remove any user from smart sheet access it still showing smart sheet sharing section. Please check and sort this ASAP.
-
Rearrange Sheet Summary Fields - click and drag
Moving summary fields one position at a time is cumbersome and unnecessary. Please add functionality to those fields to allow a user to re-arrange and/or sort as desired.
-
Automation on Sheet Summary Fields
Workflow/automation based on sheet summary fields. One scenario - count of all cells, send a warning if the sheet is close to max. (Do not want helper column as that increases the count.)
-
report rows limit with many groups filters
Hi i created a report with multiple source sheets, some columns and filtres and 3 groups. the report reach around 1600 rows but is incomplet. one of the filtres is for showing data in the next 14 days but the report do not show some dates. i need to decrease the number of dates in the filter. but i am far from the 2500…
-
Lista Suspensa Dinamica
Eu criei algumas opções de preenchimento na lista suspensa de um Smartsheet, quando a informação é viva o que posso fazer? Ou seja, quero que adicione informação na lista suspensa e não que eu faça manual a inserção.
-
How to automatically consolidate data from sheets in multiple workspaces into a single master sheet?
Hi Our structure is such that we create a new workspace for each project that we sign on. Within each workspace, lies a sheet with assignee name(s), department(s) and start/end dates for the project. We want to roll up the data from across all project workspaces into a single master resource tracking sheet, and keep adding…
-
Target Utlization
Hi, I am aware that the resource management feature in Smartsheet allows you to run reports on Utilization, but I am trying to figure out how I set the utilization for each resource. For instance if I only want Resource A to be used at 80%, how do I set that? Right now they are defaulting to 100%.
-
Request for PTO Process
I am working on a PTO process for a large team. I have a request form, goes through an approval process, upon approval processing team member receives notification, calendar (using Calendar Addon) is available for viewing by managers. My question is I would like to include an automated way that team members can either…