-
Automated import through the API
Dear Smartsheet-Community, I am doing a semesterthesis in coorporation with a company that has been using Smartsheet for a while. My job is to create an automated order tool for AM parts, which serves as an order backlog including the 3D models and part properties and that enables communication with the supplier. Object of…
-
Calculated parent % complete issue
Hello - We are using one of the templates to track a project. We track % complete at the lowest level and then use the parent rolled up % complete. We are seeing a very strange error in the parent % complete. I have attached a few examples that show the problem. You can see that the cost rolling up is not the same as the %…
-
What's with the "unnamed series" in the pie chart?
So I've created a pie chart in my Dashboard and let's say I have basic data such as: Apples 5 Oranges 12 Bananas 8 Blueberries 20 Strawberries 3 Rasberries 19 With this data, when I tried to import it as shown above, it gave me an error. When I imported only the values/numbers, it worked. However, now I cannot show which…
-
Does Smartsheet email support respond?
I have been using Smartsheets for about a year and don't seem to have much luck getting any response from Smartsheet support via email. Recently noted when they introduced multi select drop downs that the dropdown fields do not appear when you use the gmail add on. Reported this to Smartsheet via email seeking a solution…
-
Multisite Clinical Research
Hello, I am new to smartsheets and use it for work here, in the healthcare field. I am trying to figure out the best way to utilize smartsheets to track productivity for a multisite clinical trial. I have found some articles describing how you can use other products along with smartsheets to track just single site clinical…
-
Smartsheet Forms - Displaying View Only Fields
We have a SS Form that we are using to collect Project Go-Live Confidence for that month. The Form provides the PM with the Project Mgr Name, Project Name and Current Go-Live Date along with conditional questions. We want some of those fields to be View Only on the Form (PM, Project Nm and Curr Go-Live Date). I haven't…
-
Have there been updates to automation?
I've noticed recently that automation doesn't seem to be working... have there been any updates/changes recently? A basic workflow to update a cell value is not working: This workflow has been working without fail for nearly a year, and now all of a sudden, the cell value is not being updated. I cannot say how long this…
-
Resource Management Panel not showing all of the managed resources involve in the project
I manage to use the resource management panel, and also the specific sheet and resource management project also seem to sync. One issue though, I have quite a lot of people involved in this particular project. However, only 2 people seem to appear on the panel (as shown on the attached image). Can anyone help me with this?
-
Can I populate Smartsheet rows from a SQL Database read?
I have data on Snowflake data warehouse and also on a SQL server table. Does Smartsheet support connection to Snowflake or SQL database to read data and populate rows on a Smartsheet?
-
Equation to populate new number
Hello. I have a sheet with 4 columns: one is the name of the material (Material Name), the next is the quantity of that material that we have in stock (Quantity), the next one is who claimed this material (Claimed By), and then the last column is how much quantity that person claimed (Quantity Claimed). So for example, if…
