-
How to gather change orders within a project plan?
Our marketing agency uses a SmartSheet form to collect new projects (project intake sheet), then we create individual sheets for each sold project (project plan). We execute the project as laid out in the Project Plan. However, we also have a sheet to collect change orders for all sold projects (change order intake sheet).…
-
JOIN function for child row
Hi everyone, I'm currently working on a way to leverage formulas and row hierarches to create a ROW ID column. Essentially what I would like to happen for children rows to have the same "item ID" as their ancestorial row. This is what I have so far for the parent and child row formulas (currently seperate) Parent…
-
Trying to return a value once, but not when cell value changes
Sorry I don't really know how to phrase this. Basically in the projects we have, we get a quote from a vendor, and they automatically enter it into our project sheets. Because this can change to a lower price or cancelled altogether we set up automation so our price column changes to the lower cost, or to zero if…
-
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…
