-
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…
-
Sheet Summary Report with Dropdown
I'm creating a sheet summary report to use for a dashboard and have my source data broken out by phases. I'd like to be able to group the report data by phase, so I tried adding a single selection dropdown to the sheet summary. However, it's returning blank in the report. The source data is a project management / Gantt…
-
Active & Inactive Project Rows
Is there a way to make certain project rows active or inactive, so the date or % complete doesn't get calculated into the parent row? I've found a ways to use formulas to achieve this, but was curious if there's a more simple way to do this. I realize you can just delete the row if it's no longer needed. However there…
-
Filter to show only dates from this week???
I'm making a project schedule for our construction company. I would like to be able to have a filter that only shows "Start Date" that is equal to this week or this month. Is that possible?
