-
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…
-
Automatic Workflows for Sub Tasks
I am working on updating our engineering change request (ECR) process and we are moving the tracking of this process to Smartsheet. Each ECR needs a variety of things from a few different departments to be complete. Right now the process starts with a form that anyone can submit. New ECRs are reviewed by a Change Board and…