-
DataMesh & Gantt Charts
I am working on a project that we are trying to DataMesh two individual Gantt schedules into one new worksheet together. I've not DataMeshed too much, but is this possible? I use a formula of "Row # + Site #" as my unique identifier for the config. I set up the config, and the first time I kept on getting errors, so I…
-
% complete is not rolling up from child to parent.
I was sent a Smartsheet project and am not sure how it was constructed. The % complete column for the child tasks have the amounts entered. The parent task does not report the calculated rollup from the children. I attempted to fix it by creating a new % completed column and entering the values by hand. When I entered the…
-
Is there a way to merge two Enterprise Account Users?
Currently there are two Enterprise Accounts created for some reason. So I am unable to add an Enterprise User from 'Enterprise Account A' through our User Management in 'Enterprise Account B'. As per instructions, if we delete these users from 'Enterprise Account A': 1. Will their Licensed User license be removed from…
-
Vlookup from Excel to Smartsheet
My apologies if this has already been covered, but I didn't see anything specific to this subject when searching. I have a Excel sheet that has 45,000 + rows. The data in the rows are filled by 2 columns - United States Zip Code's and city's linked to those zip codes. This Excel sheet is used as a vlookup for multiple…
-
Interaction with Microsoft Sharepoint
Long story, short as I can make it. I started to create a list of links in Microsoft Sharepoint until I discovered that it seems to be woefully short with sorting, making child entries, etc. In Smartsheet, I am able to accomplish what I am trying to do with ease. Here's my question. Can Smartsheet and Sharepoint interact…
-
% Complete for a row based on 6 columns of check boxes
Hello - I have a task list that has 6 columns - each column has a check box. I am trying to determine a formula to calculate the % complete based on the populated check boxes. Ex: 6 Columns - if 3 columns were checked the % complete would be 50%, if 2 columns were checked then the % would be 33%, etc. can anyone help me?…
-
Licensed User deleted what happens to the associated License?
When a Licensed User is deleted what happens to the associated License?
-
Unable to Scroll While in a Formula
Hello, I am unable to scroll while editing a formula. For example, I am in line 648, and need to make it equal to line 45. If I simply hit =, and attempt to scroll out of view from 648 it gives me a #UNPARSEABLE error. I have been using SmartSheet for the better part of a decade, and never had this issue.
-
Integration with ServiceNow, the ITSM tool
We use Servicenow for technical incident management. Some incidents evolve into work packages for specific tech teams. These teams use SmartSheet for task management. So migrating an incident in ServiceNow to an action item in SmartSheet would be handy. Anyone done that?
-
Acceso a Informes con Acceso Incorrecto
Hola, he creado un único informe para que accedan a diferentes usuarios. Estará configurado el informe para que muestre las líneas en la que, la cuenta de usuario coincida con la cuenta de usuario que crea la línea o cuando coincida la cuenta de usuario con una columna con fórmula cuenta. Este informe funciona…
