-
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…
-
How to delete a card lane?
Please explain the ways to delete the card lane.
-
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 %…
-
Calendar App / Contact Lists
Does anyone know if there is a way to NOT display a contact's full email address (but show their name, instead) when they are assigned as "Task Owner" in the Smartsheet Calendar App? We have a calendar that references an existing Smartsheet - Sheet. The sheet has a contact list column labeled "Assigned". When the this…
-
Iterative Functionality (circular reference) in smartsheet.
I'm currently trying to find a way to do a simple iterative count using the automation tools in smartsheet. Simple iteration is one of the most basic tools in computer based problem solving, so it seems like a good feature to have built into automation tools. The specific situation is that I want to track how long a card…
-
Contact list "allow multiple contacts per view" & Card view
Hi community, I am facing a problem with a specific sheet and can't find a suitable solution. Every helping hand is really appreciated. What's happening? I have a sheet where our colleagues are listing their projects. There is a row for the name of the project leader. This row is defined as "Dropdown list" with the setting…
-
missing source appearing on Dashboard
A dashboard that I use daily now appears with "missing source" in a number of places and I have double checked the source is not missing and I am the owner of the dashboard and the source as they appear in the same workspace?! This issue appears since the latest relaese! Has anyone else experienced issues since the new…
-
Project Schedule Baseline - Is History Kept when Re-baselined?
We are using the Project Schedule Baseline functionality, but recently learned that the Schedule can be Reset or Removed. Is there anyway to track how many times a Schedule has been 'Reset' or 'Removed' and baselined again? Our concern is that without the history being tracked on how many times it's been reset, we won't…
-
Counting number of times a deadline is missed
I need a formula for a sheet summary that I just cant wrap my head around, might even be two formulas working together...Maybe I am over thinking it. I need a formula to look at a "date1" column and a "date2" column on a sheet and then I need it to count the number of times the difference between those two dates is more…
-
Averaging Health Status for Parent Rows based on Average of Children Rows in RYG.
Hi everyone, I am looking to find the best formula to give me the average health status in RYG for the parent rows (#2). I have tried IF formulas but keep getting parsed errors. Please help. Also looking to get the formula to the sub row (#1- where the picture says strategy session or AI POD etc) to the parent as well. Any…